I actually really like the photoreal stuff. Most of the US stuff I have is Megascenery Earth, purely due to their coverage. I have a few Newport sceneries as well.
I'd avoid the Taburet stuff as that tends to be satellite images with a weird green cast to them.
A good graphics card and some playing with the mipmap setting in the fsx.cfg now have me flying nicely over most photoscenery.
I like being able to look out the window and see the real world. Landclass stuff is an improvement over standard, but still suffers a lot of the same problems (roads running through water, golf courses etc).