The PS3 could be a reason why the water effects are rather low. I've never touched PS3 development but I do know that efficiently performing water that looks nice is always hard to make. I can't find a 360/PS3 video of great water right now..