I use both FS2004 and FSX.  For FS2004 I have REX installed but have never purchased the FSX version.  In FS2004, using the REX textures, I have water textures the way I like them and...for those waterways I am personally familiar with...as close to realistic as possible.

In FSX I am struggling, especially with inland waters like lakes and rivers, to see anything realistic.  The waters all look very, very dark...bordering on black.  And no, it's not missing textures.  If you get close to the surface you can see some dark, dark blue color, so not completely black.  I looked at the texture folder to see if I could replace the way the inland textures looked, but the only water texture file I could find was "water.r8", which I could not edit.

I also use ORBX FTX CRM and thought perhaps it had altered the textures so I see more blackish water than bluish water, but I could not find a water texture anywhere in the ORBX files, so I'm thinking this is default textures used by ORBX. 

Here is what I should see when I approach Anderson Ranch Dam Reservoir in Southern Idaho...

And this is how FSX looks...

I'd like the second screenshot to look more like the real picture.

Ideas?

Randy

Off the top of my head get REX 4 Texture Direct for FSX.  I can't think of a more cost effective way to get a result similar to your REX product for FS9.  I don't believe ORBX FTX CRM changes the color of your water texture.