You might find something on a site like this:
https://www.creativeuncut.com/
or Art Station
https://www.artstation.com/channels/game_art
or a noodle around a search engine to see what pops up?
As I've written in other places on this site, my writing is cheap therapy for me. I write out what I want to happen from the POV pf my little corner of reality/fantasy.
I don't care if anyone likes it or if anyone reads it. The act of writing is what I need.
I try to avoid characters having sex in my writing. It isn't part of what I want to tell.
I have a character that is more courtesan than anything else, but even there it is more to do with the people they know and the "dirt" they may have on them.
It makes for an interesting if precarious life...
In my current WIP I have 2 characters that I know are part of the LGBTQ+ community.
I doubt the reader will make the link as I have no idea on how their personal life will affect their judgement or actions.
If it comes up, it comes up. I'd deal with it then.
I'd lack to add...
How the West Was Won [1962] Three directors, three cameras, and nearly 3 hours run time? What's not to love?
I'm not sure I could have sit through all of it in one go.
In the UK you can also add:
Aberystwyth Noir by Malcolm Pryce. 7 books set in a current but alt-time line of Wales where Druids act like the Mafia.
Rivers of London by Ben Aaronovitch. 9 books in a London with spirts and magic and Met Police wizard.
Neverwhere by Neil Gaiman. Again set in...