Do you mean vBSEO? I use it. It definitely helps you rather than hurts you. I'm not going to go into detail, but from a price to value standpoint, its worth it.
The primary issue is that a lot of database driven software programs write URLs in such a way that is search engine unfriendly. That is not to say they can't or won't index the site.. but you certainly have some advantages.