I love adventure titles! The best ones are evocative and engaging right from the start. I also agree that the 5E adventure titles have been ... somewhat lackluster. They have a feel of "design by committee" which makes them safe and rather boring. But not all of them! Here's some of my off the top of the head thoughts.
Lost Mine of Phandelver - Great title for a great intro adventure, though I think it would have benefited from a different focus. "Secrets of Phandelver" or "
Hoard of the Dragon Queen - I love this title! Hits the notes I want, gives me as a DM and player something to glom onto.
The Rise of Tiamat - An OK title, but not bad overall. A bit on the nose perhaps.
Tyranny of Dragons (as the completed version of the two above) - Ehh, pretty lackluster.
Princes of the Apocalypse - Pretty awesome title, no notes!
Out of the Abyss - Pretty meh title, and suffers from "what else are we going to call this" syndrome. Adventure is really two stuck together - trying to get out of the Underdark and then trying to get back into the Underdark. Probably would have benefited from a shift in focus in general, so it's hard to blame the title for it I think.
Storm King's Thunder - Pretty good title I think, evocative and memorable.
Curse of Strahd - I dig this one. The villain is up and front, you know what you're getting into, and it sets the stakes (get it?!).
Tales from the Yawning Portal - Works just fine as an adventure anthology. Do I wish there was a better hook for each that focused on the Yawning Portal? Yes.
Tomb of Annihilation - I don't enjoy this one as much. It's meant to evoke a bigger, scarier version of "Tomb of Horrors" but really I think it would have benefited from a different title. "Jungle of Death" would have been better in my mind.
Ghosts of Saltmarsh - Pretty awesome title, no notes!
Waterdeep: Dragon Heist - The play on words here is the key, since a dragon in Waterdeep is the name of a coin. I don't mind this one, and since it's contained within Waterdeep I think the city name before it works as well.
Waterdeep: Dungeon of the Mad Mage - Honestly a bit bland. I would have preferred the name Undermountain to be in the title since that's what it's all about. Or, alternately lean out of the dungeon and go with something like "Cackle of the Mad Mage"
Baldur's Gate: Descent into Avernus - Uggh. Do not like this title. Yes it starts in Baldur's Gate, but it really doesn't have a lot to do with it after about level 4ish. Either drop the city title OR drop Baldur's Gate into Avernus rather than Elturel. Any title change I think would necessitate a shift in focus for at least the first part of the adventure.
Icewind Dale: Rime of the Frostmaiden - I love this title, even with the geographic location (which at least makes sense since it does take place in Icewinde Dale). No notes!
Candlekeep Mysteries - Sure, it's OK for an anthology around mysterious books at Candlekeep. Kinda boring but the meat is in the individual adventures.
The Wild Beyond the Witchlight - A+ awesome title, no notes!
Journeys Through the Radiant Citadel - I would have preferred something more like "Radiant Citadel Stories" or something like that since it's a compilation of unrelated adventures, but it's OK.
Dragonlance: Shadow of the Dragon Queen - I don't mind the setting in the title, but big yawn here. The adventure focuses on an area of the War of the Lance that hasn't been touched much, so I would have preferred something like "March of the Dragon Army" or something.
Keys from the Golden Vault - A solid title for an anthology I think.
Phandelver and Below: The Shattered Obelisk - Hmm. This one likely suffers from having to re-write (somewhat) Lost Mines of Phandelver. Maybe "Mystery of the Shattered Obelisk"?
Light of Xaryxis - While I overall have issues with it, I think the title for this Spelljammer adventure is pretty great actually.
Turn of Fortune's Wheel - A+ awesome title I think, no notes!