Fluid has been one of the hardest things to get right in computer generated imagery (CGI). Recently it's been getting much better though and it's finally coming of age. Here's a great video of realistic-looking water that's completely computer generated.