evil_genius_180 suggested Scriptis to me in the welcome thread. I've just been watching some of the videos and it seems pretty awesome stuff for static props. It even looks simple enough for an old coffin dodger like me to give it a bash, hehehe.
http://www.pixologic.com/sculptris/