I suggest you give it a try. The normal, find a sword and a shield, beat the first dungeon, while you learn how to play -sequence in the beginning is pretty boring, but once you get out of the Kokiri village, that's when the game starts.
As said, since practically everything has been done in games after OoT, it propably doesn't impress as much as it did ten years ago, but the game is great even if it wouldn't be "impressive" today. There's a lot of things to do and things to find, outside the main story and 100% completion is nearly impossible without the stone of agony (before someone says anything: without the help of).
I find TP and OoT very different kind of games, as a whole, OoT being better. And as some people suggested, ALttP would be worth a try too.