Super Mario 64's camera is pure jank, if it were released today the game would be panned. As a rule 3rd and 5th-gen games aged poorly, with some exceptions like SMB3.
I consider most 4th-gen games aged well, though, and can be enjoyed even without nostalgia glasses. Also a lot of PC titles from the 90s handle kind of OK.