SimCopter allows you to fly around SC 2000 cities, but it's not that good of a game and the graphics are ugly even for late 90s 3D. I don't think it supports any kind of 3D acceleration either.
The game is about tight management. My town got near 300 people and never ran out of food. I made myself a formula that I should have 1000 reserve food for every 10 people. Seems to work. Use trade when you are having a bad year and you can manage. In the end what made me gave up on the game was the frustration of not being able to build on hills.
this is for an older comment about sim city 3000. the sound glictched and play over and over and i looked it up and there was a solution but i forgot and it made the game run weird.
SimCity 2000 on SNES is the one I played and enjoyed the most, had a city going on for more than 3 years playing on and off. Oh good old times You know, the 64DD version is pretty cool I have to say. I own it and played with it around a bit, despite being all in japanese it is playable to certain extent, I haven't looked around but there must be some online guides or aid for playing it without knowing japanese. What I found the coolest was that you can move the camera freely around the city in 3D and zoom in to the street level and see the people moving around. Even though it's just the same 4-5 sprites repeated on and on, it's pretty rad. You can also catch events like robberies and such going on, which is cool as well.
Simcity 64, the 64DD only game, is now playable on at least two N64 flash cartridges, the Everdrive 64 (using Saturnu's ALTernate OS) and the 64Drive, meaning that you no longer need a 64DD to play it. Also, there's a partial English translation patch available, so I finally got to play Simcity64, and it's *fantastic*! Sadly, much of the game is still in Japanese, but you can play it well if you think/guess at what much of the Japanese text says, and if you play it enough then you'll get to associate certain text with certain results. But thankfully, the hacker who has made the partial translation is working on a full translation (though apparently he has several projects in progress, so don't expect a full Simcity 64 English translation too soon) and I'm going to wait for that to be released. Then I'm going to immerse myself in city building even more than I did nearly twenty years ago when Sim City 2000 came out on the PC! You can read about playing the 64DD games on a non-64DD equipped N64 or an emulator at: http://assemblergames.com/l/threads/64dd-cartridge-conversions-released.56654/ and download the game roms from: http://bsxproj.superfamicom.org/64dd/dump/
You have 2 options here, in my opinion, if you want to walk around in a decent looking city: Cities Skylines with mods(honestly your best bet, a very fun game) or SimCity64DD, fun if you get the partial language translation and learn what everything is / does