Photorealistic means just that - when rendered, it's hard to tell it's not a photo.

Personally, I prefer painted textures. My style is not photorealistic, generally. But a lot of people love those photorealistic textures, and the price for them is generally higher.

Examples of photoreal textures: SteffyZZ's, and the "Hypereal" textures by Morris and Face_off.