It was great back then (it got around 95% score on average by gaming reviews), and frankly, even many years after, it’s not the ugliest in this list.
I think it was almost the default game on Nintendo 64, or at least the demonstration game from Nintendo, to introduce its new camera control. Let’s start directly with the obvious one here: Super Mario 64. Get a list of my 24 favorites games (with links) to play on Retropie, Recalbox or Lakka