007 Goldeneye N64 did have (surprisingly modern) dual stick control layouts ... but it required 2 controllers. Of course it was ruined by how shitty the stock N64 controller was, never-mind having to hold one in each hand.
Here's a video of someone playing with the "2.2 Galore" control style