Though I am all for Carrara and Hexagon, like you, being fairly accomplished in Photoshop, I started with Bryce. For the price, it still is a very good introduction to 3D and you can stay with it or spread your ideas wider. Have a look at the Bryce gallery here on Renderosity. Pretty good stuff.

bwtr