Super Mario 64 Splitscreen is a multiplayer mod that is implemented well enough to make it almost feel like a natural part of the experience.
Ocarina of Time Online is a mod that lets you save Hyrule with up to three other players but the experience is more about sharing than working together.