It could imply that the person has a story where they feel a sense of sadness or self-pity. Maybe they've gone through tough times and are now ready to talk about it.
A phrase like 'Tell me a yarn' can also be used. 'Yarn' here is an informal way of referring to a story. It often has a connotation of a long, perhaps rambling story that might be full of interesting details or just something to pass the time. It can be used in a friendly or casual context, like when you meet an old acquaintance and say, 'Tell me a yarn about what you've been up to lately'.
You might find it in some historical accounts of battles or genocides where the aim was to completely eradicate the opposing side. For example, in descriptions of ancient conquests.
Once upon a time, there was a couple. The wife, feeling neglected in the relationship, started to have long conversations with a colleague at work. As time passed, these conversations turned into secret meetings. She began to lie about her whereabouts to her husband. Eventually, her husband found out when he saw her having an intimate dinner with the other man in a restaurant. It was a sad situation that led to a lot of heartache and the breakdown of their marriage.
A single phrase can start a great story by creating mystery. For example, 'The door was ajar, and a strange light seeped through.' This makes the reader or listener want to know what's behind the door and what the light is.
A story of love can also be called a love narrative. It emphasizes the aspect of it being a narrative that revolves around love. For example, many classic novels are love narratives where the plot is centered on the relationship between two characters in love.
I don't think it's common. Bedtime stories are generally associated with positive things like comfort and relaxation. Saying 'no no no' to them goes against the normal perception. However, in some specific situations like when a person is very tired and just wants to go to sleep without the distraction of a story, it might be used.
No, it's not a common phrase in general English usage. Most people would just say 'end of story' without the '30' in front. The '30' seems to be something specific to a particular situation or group.