Try Genetica Viewer from Spiral Graphics. You can get a free version. It comes with tons of seamless textures that you can tweak out and edit. You can also make your own.

But I prefer manually making them. I take real photos of surfaces/textures with my camera, and make them seamless in photoshop. Then couple that with all the materials/shader, and I have some truly photo-realistic textures.