It might also have a negative influence on younger or more impressionable readers. Excessive sexual content can distort their views on relationships and sexuality. They may start to perceive such content as normal or acceptable in all forms of literature, which is not the case. Novels are supposed to be a medium for various ideas and values, and graphic sexual content can overshadow other important aspects like character development and plot if not used appropriately.
One way is to check reviews before choosing a novel. Many book review platforms or websites will mention if there is explicit sexual content in a book. For example, Goodreads often has users who will warn others about such content in their reviews.
Family relationships are also a common theme. How a gay person's family reacts to their sexual orientation can be a complex and interesting part of the story. It could range from complete acceptance to initial rejection followed by understanding. In some novels, the family might play a crucial role in the character's journey of self - discovery. Additionally, the search for love and romance is a theme. Gay characters are often shown looking for that special someone, facing the same joys and heartbreaks as anyone else in the pursuit of love.
The Witcher novels do contain elements of sexuality, but they are incorporated within the complex storylines and character developments. It's not just for the sake of it.
The Watchmen comics don't typically feature extensive sexual content. Instead, they explore deeper themes and character development without relying on sexuality for impact.
I'm not aware of any official or widely accepted 'Eragon' fanfic with sexual content. The 'Eragon' series focuses on adventure, magic, and fantasy elements, and most fan creations tend to stay within those themes rather than delving into inappropriate areas.