As someone who uses Creative Commons-licensed content from time to time, I've tended to steer clear of NC because of the confusion too.
A common interpretation (and the one I used to use myself) was that the non-commercial protection was meant to cover use of content as a fundamental piece of a commercial venture. So a photo on a t-shirt, a song being sold on a compilation CD, etc. But using a photo within the context of a blog post on a commercial blog would be ok.
It seems, though, another interpretation is that any usage that's even vaguely related to a commercial interest is verboten. And since no-one has drawn the line in the sand on this, I'll steer clear of NC stuff now unless it really is a hobby project.