FSWC

http://www.fswaterconfigurator.com/gallery.htm

FEX

http://www.simforums.com/forums/forum_posts.asp?TID=26698&PN=1

http://www.simforums.com/forums/forum_posts.asp?TID=25884

GEX

http://www.simforums.com/forums/forum_posts.asp?TID=26352

http://www.simforums.com/forums/forum_posts.asp?TID=26682

FTX

http://orbxsystems.com/forums/index.php?topic=3128.0

http://orbxsystems.com/forums/index.php?topic=3099.0

Note:

These are not endorsements nor I am not trying to disrespect any of the other amazing add-ons for FSX. I just wanted to highlight some of the amazing visuals possible now with the rendering capabilities of FSX and just wanted to list a quick few where people have posted some amazing screenshots.

And this doesn't even look specifically at planes, although the H1-B Special in the FTX shots does look sweet.