Silo 2 is a pretty neat modeler, although unfortunately, nothing else. Still, I find myself really enjoying working in it, as it's a lot easier to use than most commercial software out there. The basic interface is pretty self explanitory, and isn't cluttered with things you won't need, however, you can pretty much customize it to your preference, so migrating from other software won't make you feel that out of place. I've used the demo first, for 30 days, and only had 1 crash happen, so far, It has been pretty stable for me.
If you want to buy this, try it out first, as some people don't seem to like it (but that's pretty common with everything anyways). You have to keep in mind, that everyone's preferences are different, so you have to find the right tool for you. There's a similar software called Voidworld, which is free, and was practically created to be a replacement for Silo, you can try that too and make comparrisons yourself. However, it's not as optimized, so it eats quite a lot of your resources, and might not run as good on your computer as on anyone elses (I practically couldn't use it, because it kept crashing, but I have a crappy laptop).
If you're looking for other, similar commercial software, you can also give Hexagon 2.5 a go (from Daz3D). It can do pretty much the same thing, with the addition of directly painting onto models, althought not as good in that field as 3D-Coat, as some parts of the UV need tweaking before you can begin painting (if you don't want to have streched textures on certain verticles). Unfortunately, that too, like Silo, is not being updated anymore. Still, don't let the lack of updates discourage you from software if you enjoy working with them. At the end of the day, it's all about what you like, and how you can utilize your tool anyways.
Also, If you're new to 3D modeling, make sure that you understand the basics. These are universal, and not exclusive to any kind of application. If you don't know your foundations, you might feel uncomfortable and let down, after a few failed attemps at translating your thoughts into a model.