There are no real 'ghost mansion sex stories' because such stories are often just fictional or part of urban legends. They are made - up to either scare people or for some form of entertainment that involves a combination of spooky and sexual elements which have no basis in reality.
Yes, it can be. In some horror stories, the idea of having an encounter, which might be misconstrued as'sex' with a ghost, is used to create a sense of the uncanny and the forbidden. It plays on our fears of the unknown and the supernatural.
One common element is the element of the unknown. The ghost is often an enigma, and the interaction with it is something that defies normal human experience. For example, the ghost might appear suddenly in a locked room.
Regular ghost stories mainly focus on the spooky and mysterious elements of the supernatural, like hauntings, apparitions, and solving mysteries related to the ghosts. However, the idea of 'ghost sex novels' is a very different concept which combines sexual elements with the ghost theme, which is not a common or accepted approach in traditional storytelling.
In some cultures, there are superstitions and stories that involve the dead interacting with the living in strange ways that could be misconstrued as something like 'ghost sex' stories. However, these are not really about sex in the modern sense but rather about the blurring of the boundaries between the living and the dead. For example, in some Asian cultures, there are tales of spirits visiting people at night, but it's more about the spiritual realm and karma rather than sexual encounters.
I'm not aware of any specifically famous 'gay ghost sex stories' in mainstream literature. Such themes are rather niche and often not part of the common literary canon. Most literature focuses on more traditional relationships or different aspects of the human experience rather than this rather specific and somewhat inappropriate combination.
Ghost stories often involve the supernatural and fear, not appropriate to be associated with sex. In Indian folklore, there are many pure ghost stories. For example, the story of the female ghost 'Nagin' who haunts certain areas in search of revenge. These stories usually focus on the mystery and horror of the ghosts rather than improper content.
Most mainstream literature doesn't really focus on such inappropriate content. Literature usually emphasizes positive values, moral lessons, and meaningful stories rather than such vulgar topics.
There are some fictional stories about such themes in horror literature. However, these are often just products of the imagination. For example, in some old horror tales, a character might claim to have had strange encounters with a spectral figure that seemed to have a form of 'interaction' that could be misconstrued as such. But in reality, it's all in the realm of superstition and spooky storytelling.
Yes, for example, the story of Casper the Friendly Ghost. Casper is a kind - hearted ghost who just wants to be friends with people. He doesn't have any malicious intent and there is no sexual content in his story. It's a story that can be enjoyed by the whole family.