Pretty much the only places where FSX looks good "down low" are the cities and the areas around different airports (assuming you sprung for the 3rd party add-ons).

WOP, looks good, but I wouldn't say realistic given the filters, and the view distance, and the lighting and claustrophobic map sizes.

FSX, WOP, and IL-2 have pretty much peaked. ROF and CloD are the only two that are going to improve given they are newer (newish) game engines. The two of them are (compared to MS) tiny, tiny developers, with limited funds and staff, so improvements and upgrades are going to be "bite sized" instead of huge Service packs that radically alter or improve the game. Also it's yet to be seen if there will be an active 3rd party industry centred around these two titles.

MS's "Flight" is looking to be "FSX version 1.5" so I don't see it getting much better, and probably sticking to the Satellite Photos method that has done MS well so far.

You've got to remember that FSX and Flight are Procedure sims, while CloD is a combat sim. They each have their strengths and weaknesses.