If you want another CS level, Italy Inferno has a ton of photogentic spots in both Source and GO. I'm also particularly fond of Lake, but that might be partly the 500 hours of Wingman on the map speaking.

Edit: or for Valve games in general, theres the dam from Half Life, Ravenholm or the drained shores from Half-Life 2, or an overgrown chamber from Portal 2.