Of course when authors write papers they make the title intentionally colorful to generate interest (e.g. Let's get deranged! by John C.Baez). Should this practice be avoided in main even if the user adds background, motivation or appropriate research in the full question?
I wouldn't worry about it in general; at worst, the title could be changed. As opposed to an article published in a journal, if it does fall flat it is easy to change the title.
They should be used when they help the reader understand something; they should be avoided when they distract from the topic. Thus ''Hearing the Shape of a Drum'' (a famous paper) helps the reader understand what the topic is about.