Simplicity of Sea by wskeever is my choice right now. I'm running it on top of Cathedral Waters with CW's .esp disabled.
Feels like the best of both RW2 and Water for ENB with no performance hit to speak of. It's missing RW2's effects like waterfall splashes and beach waves, but it's a million times more compatible with everything. AND it's got Water for ENB's excellent colors, while having somewhat better effects than it (I really don't like Water for ENB's waterfalls).
Here's a random pic that shows how SoS looks in unflattering conditions with no ENB, and I think it looks pretty great: https://i.imgur.com/gj4C0NY.jpg