CMIvfx has some project based tutorials in more "general" ares as well, like shading mantra, procedural modeling, caustics, assets, etc...
http://www.cmivfx.com/tutorials/view/203/Houdini+Shading+and+Rendering
http://www.cmivfx.com/tutorials/view/501/Houdini+Python+Weather+Widget
http://www.cmivfx.com/tutorials/view/213/Houdini+Procedural+Road+Creation
http://www.cmivfx.com/tutorials/view/504/Houdini+3D+Galaxy+Creation+Effects
To name a few... It's hard to know what you mean with day to day work since pretty much everything is a day-to-day work of a houdini user (generally speaking). But I agree that in most cases you'll have to connect the dots from different houdini tutorials.
Cheers
PS: 3DBuzz also has a technical effects title that's quite project oriented from beginning to end, as well as CGMasters.