I had this wacky idea for a UE video game a while ago and so I took various pictures from the gallery (at the time it was just Av's and manitou's, not sure whose photos made what textures, but that's where they came from) and reoriented them (which took immense amounts of fiddling with the distort tool) so that they would be rectangular, just to see how they would turn out. They turned out... lackluster. But if the photos had been taken with the express purpose of being turned into textures, I'm sure they could have been twice as good.
Someone had already mentioned that Stelco would make really great video game textures, so here's
a directory with a bunch of them for you to check out.
Some of them aren't great just because of the angles and the lenses the original photos were with and the fact that I didn't spent hours fussing around with the quality. But they're there nonetheless.
It really would be nice to at least make a virtual walk-around of some UE locations, if only as an excuse to spend more time there taking photos and mapping.