Hi,

MoI is particularly good for creating hard surface models. But then you still have to create UV maps and textures for your models.
Here's a cool link that can be useful for this : http://forums.cgsociety.org/showthread.php?t=373024

Of course, you need an application to create your UV maps and an image editing software... ;-)