TLDR:
If your title misleads others, it's not a good title. A good title should be able to help future visitors with the same question, not a title that doesn't provide the relative context needed to understand the question at hand.
Titles should never be misleading. I learned this the hard way, when I posted a question: What is the splash range for Jarate and Mad Milk?
Initially, I had decided on setting the title to "What is the splash range for my urine and milk", since Jarate is considered bottled urine, and Mad Milk is milk.
Apparently, my title was re-edited over to make it more "appropriate", and was approved by 2 high-rep users on this community. I understand, and respect that, because the original question title was misleading. Splash range of urine and milk gives no context to the situation. People could be browsing the Hot Questions list, and have no idea what Jarate or Mad Milk, or even what TF2 is, but see the question and be curious about it, and realize it's a bit different than what they expected.
As such, I am highly against titles which give a vague understanding of the context of the question. Sure, it's funny, and great for all your funny jokes, but at the end of the day, titles should accurately reflect the content in your question. For example, the highest rated question in this site has a funny title, but it's easily understandable. From my perspective, reading that title solely tells me "Oh it might be an RPG where you can consume corpses, like Fallout, but it's for nethack, that sounds interesting.". The title isn't misleading, and still informs users what the problem is at hand, is consuming corpses in nethack safe?
The recent questions that people have been asking on this site have been consistently geared towards getting it into the Hot Questions list. I hate this approach; the titles are vague and don't really tell me what the problem is. Sure, fun is fun, but the site should be geared towards a very serious mindset in regards to asking and getting questions. For example, the following question seems to have been geared towards grabbing attention, but doesn't actually reflect the context of the question: https://gaming.stackexchange.com/revisions/185847/1
If I read that, sure it'd grab my attention, but I have no clue what the user is asking for, and what the user is requesting.
The Question Title should be able to help future visitors. If you can make it funny, or have a title that can grab people's attention, great! But make sure that it's relevant to help future visitors. If I want to ask a question about being over encumbered in Skyrim, I could word the title as "Help!!! My Dovhakinn is really fat!!!!!!". Even though that may be funny to some people, that title provides no context to the question (what is being fat in Skyrim? what is this guy even asking for? is it a graphics issue? does it mean he ate a bunch of food?) and is overall useless to people searching for the same issue. More than likely, users will search "how to get past overencumbered" rather than a very niche joke of a title.