I was excited a few years back to finally get FogBugz set up for my new company to use on a project, only to find it incredibly frustrating to use, and dropped it like a stone.

The lesson I learned is that people who write a lot of interesting things about software development (I've read almost everything on Spolsky's site) don't necessarily create good software themselves.