Bing and Google maps used to have a 3D Terrain feature that was great. However, looks like they got rid of it.... does anybody have a similar website?

download google earth, you can still 3d and spin/toggle the maps...

yeah, in google earth go to tools<options and then set your terrain exaggeration to 3
from there you can drag the little dude in the corner of the screen (ground view) to a point on the map and the toggle and look around.