Bioshock

I played the demo too, the water graphics are pretty amazing