Definitely not. There's no way this could be a common story. It goes against normal language usage and is so strange that it couldn't be part of normal literature or storytelling. It might be some sort of made - up, offensive - sounding thing that someone randomly came up with.
In ancient myths from various cultures around the world, we find stories about the afterlife, the relationship between humans and the divine, and how to live a virtuous life. There is no room for such offensive 'guy sucks cock stories' as they go against the very essence of what ancient myths were created for.
I'm not aware of any positive or appropriate stories with such a vulgar concept in mainstream literature. Literature usually focuses on more positive, moral and inclusive themes.
Rather than delving into such inappropriate stories, we should encourage a society that promotes love, respect, and positive interactions within marriages. There are so many wonderful aspects of married life to focus on, like mutual support and shared dreams.
I'm not sure specifically what this 'sissy boy sucks daddy story' is about as the description is rather unclear and could potentially be inappropriate or just a very strange made - up phrase. Without more context, it's difficult to say.