Here's an extremely realistic water simulation (the most accurate I've seen so far actually) which will take gaming into a new age of realism. You'll probably need a physics acceleration card for it, but with that kind of realism, who cares?

It's truly a breathtaking view. It's probably only used in movies for now, but if it will make it to the computer games industry, it would truly represent a revolution! Wow!