The thing i really dug about the SNES was the top-down vibe of alot of the RPG's. Link to the Past and Secret of Mana come to mind. You used to get some really cool features associated with this viewpoint. Like being able to see a key in a another room you couldn't get to, or seeing something in one room you couldn't figure out how to reach it.
The 3D viewpoint swallowed up this whole genre of gaming, and i guess its thanks to DS, GB and PSP this style is still around.
I'd like to see a more of a combined game viewpoints-wise.
Like, in Ocarina of Time on 64, at the beggining in Kokiri village, when Link wakes up the view is directly above his head. 3D is great, everything looks more realistic and awesome, but your left with the task of constantly changing viewpoint all the time. There's nothing wrong with that, really, but in instances where the viewpoint is simply following you you can really just explore the world, rather than 'looking' at it. Which is cool sometimes to just cruise around admiring the space.
But yeah, i hope there's more of this in TP. Like, you walk into the magicians shop and boom, top-down view, like old school LTTP. But its still all 3D and stuff.
More constrained viewpoints - they add mystery, in a way, i think.
Like in the Market of Hyrule Castle in Ocarina, right as you walk in, the camera is set right above you. Thats sweet. I'd like to see more of that.
Sounds lame i guess but yeah, i love it.