hi hi!! (it only sent once btw! and sorry for taking so long to respond!) lesbian media... it is soo hard to find good lesbian media for real... if i'm honest the overwhelming dominance of the male gaze and heterosexuality/piv-as-default means that navigating lesbian sexuality in media, even fan-produced, is annoying at best, so i don't know how well anything i recommend will suit what you're looking for orz. and thank you for enjoying my fic !!

fic: i don't think you need to know the characters/idols before going in, although it may help.
kindergarten girlfriend: https://archiveofourown.org/works/18579910 : lovelyz. cws: alcohol addiction, complicated relationship. not exactly horny, but it is special enough and feels so real to me that i wanted to include it.
wear it out like a sweater: https://archiveofourown.org/works/26073718 : fromis9. yeah horny and tense . but also sweet and fun.. this author has a lot of good f/f works so i won't link too many here
tilted moon: https://archiveofourown.org/works/20308036 : wonder girls. lesbian / bisexual woman in denial, all the mess and cruelty therein.
the red country: https://archiveofourown.org/works/393136 : alice and wonderland prequel. basically a novel.

nonfic, idk if i'd call them horny but definitely frank about lesbian sexual desire:
tár: film, which i have not seen, about a wildly famous, wildly toxic cate blanchett
gia: another film, tense and messy and tragic.

lesbian works that are not tense or horny, but which are dear to me:
annie on my mind: classic coming-of-age novel
a secret love: beautiful netflix documentary about a lesbian couple together since the 1940s
the incredibly true adventure of two girls in love: another film
fried green tomatoes: film. a classic. so so so so special to me.

i hope you like some of these orz it is hard out here for lesbians for real