Actually, I respectfully disagree with the last post.
I think Houdini is for you if you are NOT technical (but want to do things other than the simple canned things other packages give you). Can you imagine having to write all the MEL scripts to do some of the things you can EASILY do in Houdini?!? To me, scripting and plug-in writing is technical. People seem to forget this when a production says “We did this in Maya!” - yeah with a team of programmers…
To be honest, I am fairly technical, but I find Maya almost impossible to do half the stuff I want to do in Visual Effects work that isn't a simple push button canned effect. With Houdini it is pretty fast and simple. And now that I have learned Houdini's character tools, I find trying to learn Maya's fairly complicated and inflexible and restricting.
Plus in reality, production is about re-do's and making changes easily and managing work from several different people and bringing it all together. Houdini does these things WAY better than any other package.
Let's face it- Houdini is a little weird compared to other packages and it does take some more in-depth understanding of 3D to use, but once you get the hang of it, the whole package opens up to you since it is very consistent with itself and it isn't buried in confusing nested menus. In my opinion, if you are a CG professional and know how you would like to approach a problem if given the option to using a different tact, then you are technical enough for Houdini.
-Craig