You can use it when you want to end an argument firmly. For instance, if someone tries to continue a pointless debate, you can simply say 'period end of story' to shut it down.
For example, if you are chatting with a friend about books, you can say 'I'm looking for a new fiction writer to explore'. This shows your intention to discover new fictional works. Also, when you want to recommend a book, you can use phrases like 'This fiction novel has an amazing plot'. In a more general conversation about entertainment, you can mention 'I'm into the fiction genre lately'. By using these phrases, you can clearly convey your ideas related to fictional works.
When trying a new food that is a variation of something you've had before. Like if you try a new type of pizza with some different toppings, you could say 'Here goes nothing novel' as you take the first bite.
If you're in a discussion about a movie or a book. After you've described the plot, the characters, and the ending, using 'that's the end of story' is appropriate. It tells the others that you've covered everything you wanted to say about that particular movie or book and you're not going to add any more details or interpretations.
You could say 'When he said that one word, it was like the latin for end of story, and everyone knew the matter was closed.'
You can say 'His confession means end of story for the court case.'
You can use it at the very end of your piece to clearly mark the conclusion.
You can say 'We've reached the deadline, eos end of story.' Here it shows that the time limit has been hit and there's no more to discuss about it.
You can end a conversation by introducing an external distraction. For example, a sudden noise or event that forces the characters to stop talking. Or maybe a character gets a call or text that they need to attend to.
Good conversation stories can be used to break the ice. For example, at a party, sharing a funny conversation story from your work can make others laugh and start a friendly chat.
These quotes can also be used in conversations to make a point more effectively. If you want to talk about the importance of perseverance, you could bring up 'The man who has no imagination has no wings.' from Muhammad Ali (which has been used in some novels). It makes your argument more interesting and memorable.