The only one I can think of on N64 that's 2D is Mischief Makers. It's a great game, but here's a very fair comparison, against Silhouette Mirage from the same dev (top is Silhouette, bottom is Mischief):
Silhouette looks cleaner and more impressive imo than Mischief.
It wasn't until recently when I read another thread on GAF that the PS1 was VERY weak with 2D sprites (news to me), I was always under the impression it was a 2D beast (though the Saturn was king there). Apparently the sprite in Symphony of the Night weren't true sprite but a 3D model that was flattened or something (?!!!!)
But PS1 did have a lot of 2D stunners.