It's definitely still "user hostile" software, but I hear anecdotally that recent versions (post 1.4 I believe, post 1.5 even more so) are much improved over even 6 months ago. I've been using it mirroring svn at $work on my desktop to have my own local branches (rather than resorting to svk or kludgy scripts to try and do it correctly in SVN) and I've been very happy with it. I admittedly haven't been using some of the fancier features (like git-bisect), but what I have used works pretty well and when I have hit problems #git on freenode has been very helpful working things out.

I'd also check out Mercurial as well if you haven't, as the feature set's mostly the same as git. I did most of my initial DSCM experimentation with hg and then moved to git with no troubles. (As for why I switched, I just "clicked" better with git than hg when I actually started using it more extensively I think.)