Banjo Kazooie: Nostalgia 64 is out. The biggest mod for the game by far, years in the works. A full game set across the N64's library.

Tons of effort went into it. It's not quite as transformative as some Mario 64 hacks (which have the whole thing decompiled) but it's an impressive piece of work!