Not relatable for me, but I am sorry you feel that way.
For me, since I know for a certain fact that I will never in all my life have sex with a beautiful woman or a relationship resembling anything you'd see in these fictions, I cope and temporarily try to escape with this art.
When all art/games/movies are woke slop now and they just fill it all up with fat gay goblins we don't even get our escape anymore.
Pretending sure is hollow and empty though ultimately -- it's no replacement I know that, but it's probably better than nothing.
What DOES make me relate to the feeling you're describing is seeing true beauties out and about in the real world. That's when the pain hits me knowing that there are genuine 11/10s out there -- young women you know just at a glance would give you healthy children and that you'd trade everything for a shot at being with them. And yet you also know they would never in 1 million years consider being with you ever and there is a 100% chance they are taken and also have had a rotating list of Chads rail them over the course of their lives and also that if you dare say anything to them they'll react with revulsion and irritation before huffing away from you.
That shit is suicide fuel. Needing something you know you can never have causes intense agony (I see "needing" not wanting because sex and love are deep core human needs and a huge cohort of young go without even if they do everything right and aren't antisocial tubs of lard). Our system is just stacked too hard one way because we removed all the "balancing" factors that our societies used to have to keep men and women 1 to 1 with each other.
And nobody seems to notice, nobody seems to care -- 99.99% of all women are completely delusional on this subject as well. They erroneously believe men are oppressors and they are victims in western society because they've been propagandized by fucking retarded bullshit their whole lives and no one has done anything but encourage such delusion in our time.