Adventure of Link as someone already mentioned it's incredibly generic and most likely will always be considered a generic title.
While I can agree Twilight Princess sounds tweeny now, it doesn't mean it will stay tweeny forever. There was a time when Twilight wasn't considered a soiled word, just look at the twilight zone.
Adventure of Link is a great title though. It says exactly what the game is. It's an Adventure had by Link. The title tells you exactly what the game is.
The worst in my opinion would be:
Freshly Picked Tingle's Rosy Rupee Land
Colour Changing Tingle's Baloon Trip Of Love
Both of those game titles are pretty shocking. They don't give the impression of a good game, they give the feeling more like some artsy fartsy 99 cent game full of toxic micro transactions.
If I have to pick a more mainstream Zelda game I'd choose:
A Link To The Past
I lever worked out what the past has to do with this game. There's no time travelling in the game. All Zelda games have the Link to the ancient gods and the triforce. So what's special about the past and this game? I never really liked this title for this and other reasons. I just call the game Zelda 3. Incorrect I know but it's a heck of a lot better than ALTTP.
Said it once. Say it again. A link to the past. The JP title, Triforce of the Gods, was mich better
Yes sir it was. You are correct.