I just wanna see how people work together, even and especially when it's hard and complicated!

Exactly!

when I was a kid, I was obsessed with books where the main couple DIDN'T end up together

There are definitely movies and books with unhappy endings that I love, but I took this mostly as fanfiction tropes, and I do prefer a happy ending there (except with Remus/Sirius because of canon).