I prefer the Git command line interface over any GUIs I've used.
I do think it's worth using on small projects, and have even used it for quick single page sites.
I don't think it's for everyone in the sense that everyone should be using it. There are too many variables from person to person and project to project to accurately cover them with the "for everyone" blanket. That said, I'd certainly recommend Git above any other revision control system, but I don't believe it is necessarily the right answer for everyone.
Only wish I'd learned it sooner: