I'm probably in the extreme minority when I say it, but, to me, Tamagotchi 64 looks
amazing, admittedly I have a huge soft spot for video games that use 2D sprite graphics and mix it with 3D backgrounds (Which is why I also love games like Paper Mario so much).
And what about Shiren 2, also on the Nintendo 64 (note, Shiren 2 isn't the full title, it's not even 20% of it) looks pretty okay now, though a bit barren. I love the very earthy colour palette is uses.
Goemon Sugoroku of Mononoke also looks quite nice, though, it is made on
only 2D sprites, so it's expected.
Also, notice that all of the above games that I just posted are all heavily sprite-based games, haha. Well, Shiren 2 has 3D backgrounds and 3D objects in said backgrounds, so eh.