My personal choice would be C&C Red Alert 3, that game has such a gorgeous looking water with awesome physics too. It still holds up today imo.