I have always used Photoshop. Granted painting on a 3D surface would be nice, but I have seen and done some rather impressive texturing in Photoshop. Tools like EyeCandy 4000 and Flaming Pear can have almost endless options.