People still quibble over that title choice, despite this being a children’s book about a school for wizards with a magical train ride and many other fanciful notions? Why?
Waves from upthread. 
Because “Philosopher’s Stone” is an actual thing from alchemy, and “Sorcerer’s Stone” isn’t anything. It’s a pointless change from the original.
Ding! ding! ding! ding! ding!
I disagree that the quality of a title is related how well it explains the plot but I think your example of Faster, Pusscat! kill! Kill! is interesting because I have no clue what it is about and can’t even really hazard a guess. Contrasting with Room which gets you a decent way there.
It’s such a minor change that I don’t see how it matters much.
Licorice Pizza. I grew up with the record stores but the film still has nothing to do with the title except a correlation with Southern California and the 1970s.
I’ve never seen it. Going by the title alone, I would say it is a 60s sex romp spy spoof along the line of Matt Helm movies. Probably with female driven mayhem using gender reversed roles.
Looking it up…well, I was maybe half right. Russ Meyer! I should have known,
I would contrast it with 2003’s “classic” The Room. Or 2005’s Room. Or 2019’s The Room.
I dare you to tell me what they are about from the titles, except that they all involve a room. 
Make sure you get the right one when you want to watch it. Don’t be like me, when I grabbed The Robe off the shelf when I wanted Rope sitting next to it.
Roger Ebert could not stop laughing at:
Highlander 2: The Quickening
The NeverEnding Story II seems like a title that shouldn’t exist.
I think Troy McClure sued them.
Lionel Hutz.
They sound alike, it’s an easy mistake.
Or the ones containing names that very few people have heard of before, such as Metalstorm: The Destruction of Jared-Syn - is that a place, a person, the villain, the hero?
Blade Runner is, I think, a terrible title because it’s meaningless. Though the title of the original novel isn’t much better; Do Androids Dream of Electric Sheep?
Blade Runner is a great example. It is the more violent sequel to Kite Runner? A comedy about an Olympic skater that wants to compete in the summer Olympics (Starring Will Ferrell?) A biopic about Oscar Pistorius? Or a futuristic movie about android assassins?
I remember this list from a half an hour ago, so I think I just passed a cognitive test.
Amityville Death Toilet
The king of misleading titles:
Tons of titles are merely misleading.
Leonard Part 6. Bad title, worse film.