In SimCity 4, you have the game's plane-like view, but there's no ground view available.
It's quite easy to find good (and accessible) views of the Honolulu skyline. Though, it's actually quite hard to find a place where you can get the entire skyline in one shot.
Here are two panoramas of the rest of in-town Honolulu (Capitalis) from Punchbowl (Juicebowl) Crater:
[i'm sorry, something was on my lens...]
Diamond Head (Pearl Head) Crater is the most recognizable landform in Honolulu. Here are some pictures of the latest hike to the top I took: