A 'wife creampie contest story' is not a common or appropriate topic. If we assume it's a fictional and inappropriate scenario, it would involve inappropriate and unethical content which we should not promote or discuss in detail.
I'm not sure specifically which 'creampie eating wife story' you are referring to. There could be various fictional or made - up stories with such a title. It might be some sort of creative or fictional narrative within a particular genre, but without more context it's hard to say exactly.
No, it doesn't seem to be a common type of story. It's a rather unusual title and concept. Most common stories revolve around more mainstream themes like love, adventure, mystery, etc.
Rather than seeking such stories, we could shift our attention to healthy relationship stories, for example, how a couple overcomes difficulties together and grows stronger in their marriage.