Control schemes showing their age.....
Now many of the 3d cameras, especially those before we moved to proper dual sticks, will not hold up favourably and doubly so since we have still not come close to making a proper camera for a 3d game let alone back then. Still Zelda style z targeting worked OK for a lot of things, RE4 stop and shoot and straight over the shoulder locked camera all do well enough with proper level design.
This is probably where your 10-15 years comment comes into play though as the N64 is going on 17 years old now (about this time in June 1996 in Japan), the PS1 is a couple of years old give or take a few months and early mainstream full 3d was shockingly poor at holding up. Even worse if they tried something like you might see in modern games (resident evil works well enough though that was prerendered, vagrant story I can still play, MediEvil on the PS1 I can still enjoy but that was also a dual shock game).
Back on controls
Platform was a solved problem more or less coming into the NES and master system in terms of home consoles, was doing OK ish on the PC before then and even on the C64 it did OK. I will lump shmups in there as well.
Mouse and keyboard pretty much solved FPS and had done since around Quake and the ability to look up and down. That said even those that did not care quite so much for up and down did OK.
Driving. This depends if we are going 3d or top down/isometric. Arcades solved the latter years before and though the earlier attempts at full 3d (looking at many amiga efforts) the race to the horizon games more or less sorted that early on as well.
Flight games. Given we got to lament the passing of joysticks....
Now bad controls will probably always be bad controls (barring hackers coming along and fixing them of course*) but controls themselves have largely been a solved problem as long as the technology has been there to display it, which is basically forever though there will be milestones if you look at actual history.
*actually automated macros, programmable controllers and more existed even back in the day.