I can't really answer one way or the other because there's a lot of nuance.
I think that "done well" can only truly be done by people who are themselves LGBTQIA+, because when cishet creators attempt it, no matter how hard they try and how much they research, it always becomes some unrealistic feeling combination of misery porn, inspiration porn and self-congratulatory patting on the back of both themselves and the "enlightened" audience. I think that's because the "oppression" angle seems to be particularly fascinating to cishet creators, especially if they're white and middle class, because oh boy, you can live out all your emo fantasies about being oppressed while having a white middle class protagonist like you and have boy on boy or girl on girl action!? Hot damn!
Because of this, I'm just really tired of the tropes of LGBTQIA+ oppression in mainstream media. Every damn movie about lesbians for a while was set in the 20th century and had a sad ending so the audience could be all sanctimonious like "thank goodness nowadays there are good people like me who accept lesbians!" while they enjoy the gratuitous and hilariously unrealistic lesbian sex scenes... (if you believe cishet dude film makers, sex for us is just kinda... rubbing against each other sensually while making sure to be positioned so a hypothetical onlooker can see our boobs...).
Like a lot of LGBTQIA+ creators, I mostly just want media to treat us like we're normal, and like we can be involved in conflicts that aren't in any way related to our sexuality or gender identity. Sure, I'm open to stuff like Magical Boy or Gender Slices, which actually really did help me understand trans identity and how it must feel to be trans, but a lot of my trans friends find Magical Boy hard to read because the scenes of transphobia and dysphoria are intense and quite triggering. Sometimes though, I just want to see people like me go on an adventure where the stakes are "Oh crap! The evil dragon king has awakened! We must save the princess!" and nobody has to deal with like... I dunno, the evil Dragon King being a homophobe. Sometimes an evil dragon can just be evil and oppose the heroes because he wants to destroy the city or whatever, and the lesbian hero can just be a hero because she's brave and has a cool sword. Stuff like "To Knight the Faithless" is really cool for that.
Sometimes you just want a break from being reminded that you're "othered" by society, or fetishised, or exploited for drama, you know?