Very good question, I too would love to see what masters suggest.
IMHO learning Houdini and learning visual effects (which is art) using Houdini are two different questions.
For the first one i think the advantage we don't have now is growing with the application/tool as it evolves.
H has quarter century of rich history and has become software so wide and deep that its intimidating,even for seasoned folks in other tools, to do something useful with it initially.
Its even tougher for the folks who don't have strong technical background. So they are at ease learning Computer Graphics using it. That essentially means learning required Math, Physics, and Programming, which demand time and dedication.
Manual, video tutorials, tips and tricks help with learning the tool but for the second question unfortunately there aren't many books* or resources available. So one is better off under the tutelage of a master or group, where one can learn the art and craft ,discuss various approaches, get direct feedback on the work done and improve.
* ( http://elementalmagic.blogspot.in/ ) is the only book i know which talks about the art of special effects animation.
Would be great to have material/resources which talk of both aspects.
Any suggestions ?