The Japanese-only N64 port of SimCity 2000 (not to be confused with SimCity 64, which was for the 64DD) is probably the most bizarre port of a video game I have ever played. It of course, weebs-up an originally American game by adding things like anime cutscenes and a dating sim, but it also adds a sci-fi story arc to what was originally an open-ended city builder.

Basically, you start off building you city until scientists discover an asteroid heading towards your city. If you get a high enough population, by 2015, some benevolent aliens presumably relocate your entire city (including the buildings and literal landscape) into a space-ship. There are even minigames where you battle evil aliens on your multi-generational journey across the stars. Once you reach a population of 1 million people, the generation ship carrying your city lands on a habitable planet where you can unlock a free-play mode.

There are also things like a horse-betting minigame and some minigame where you try to create some GMO crops. Though I do have to admit that the BGM for the space attack minigame is really good.

https://fi.zophar.net/soundfiles/nintendo-64-usf/sim-city-2000/sparse13.mp3

But yeah, I can clearly see why it wasn't localized, but I actually do find the idea of a story-driven city-builder quite interesting. It kind of makes sense for a console game where people expect an actual goal.