Tag Anywhere for Donkey Kong 64 makes it at least playable in this day and age (I still don't think it stands up but it removes the most annoying part of the game).
Master of Time for Ocarina of Time is incredible.
Super Mario Star Road is basically a direct sequel to Mario 64.
Tomorrow Never Dies is a 13 level new Bond game based on Goldeneye 007