The Picture City world from the first Rayman game is pretty great. Sky Sanctuary ( both versions) from Sonic Generations is also great. I agree with anyone who mentions Rapture from BioShock, as well.
---Member of the official Squeezol Fanclub---