It's not about content. It's about finding the right word combination to convince Google (and friends) that your site is the most relevant one for a keyword and then finding lots of folks to link to it.
I hope that one day it'll be as simple as "the best content wins" but anybody who searches for nearly anything on the internet knows that's not true today.
The About.com's of the world don't have the best content, but my god do they have link-farming and keyword targeting down to a science.
For example: I use a variety of synonyms and phrase combinations when writing copy not to trick SE's but to help people who are searching realize that my content will answer their question or solve their problem.
At the end of the day, I truly believe that it is about content. If I create, distribute, optimize (etc), the best content, that has a huge positive effect. People recommend my content, trust that I'm a valuable source, etc. All things that are important in our new social internet.
About.com, Mahalo, etc rely on the lowest common denominator of content and spreading as much as quickly as they can. It's working right now, but I'm quite confidant that won't work for long.
They're the only paid toolset that I use (for SEO). That's about as good a recommendation as I can give.
That said, if you're not running a fairly serious site, I'd give it a miss. It's not a toolset for just playing around with (hence the price).
I see Rand Fishkin from SEOMoz commented on here which is neat. I've thought about becoming a member of his site, question is, is it worth it? I'd love some feedback from people that use SEOMoz's tools.