Disclaimer: I'm not an expert, I just play one on the Internet :)
In my opinion, websites do not bring much to the table to that kind of SMEs, unless they offer some added value (online booking or something). They're just the modern equivalent of a Yellow Pages listing. A creative company probably can add a lot more value though, but I don't think a website drives business unless it becomes a part of a wider marketing strategy (my experience is not in the U.S., it might be a lot different there).
You're also mixing two very different kinds of services, professional services like accountants are VERY different from someting like a beauty salon or a cleaning service.
Social media in general and Facebook in particular, on the other hand, bring a lot of value to the second category of business owners (beauty salon, cleaning service), and make engagement with customers a lot easier.
I think Yelp or equivalent listings are also important for SMEs to monitor.
In spite of a lot of effort by several startups, there still isn't a great solution for "local" services.