Oh man, SimCopter was an enormous amount of fun for just that reason. You could even edit cities using SCURK (SimCity Urban Renewal Kit) and build your own ideal place to zoom through. Nothing's ever really captured that fun - some come a bit close, but never with the in-person feel of it.