CMS WEB SITES PRO VS CON
Dynamic CMS web pages are not stored on the web server as static content, but rather, pieces are picked from a data base for customer presentation based on the query.
The downside is search engines cannot index CMS dynamic pages as they see them as an indefinite string of links, so they have to be supplemented with straight html page content to ensure placement or static html pages with links to dynamic content.
Google will slowly start to crawl a CMS dynamic page until it realizes the multiple URL query strings are leading to duplicate content and then it moves on. Most search engines will not spider the page at all, so the site is riding off its tags only and not it's content. In these days, when content is so important, it becomes more difficult to get good placement with a CMS dynamic structured web site.
The pro side is you give a custom approach to a customer on your site and the site can be self maintained. This is great if you are so well branded that they can find you with your URL (e.g. www.nike.com) or if your advertising materials are so strong your customers get your web address off print material almost exclusively.
For the most part, small businesses should avoid CMS dynamic web sites, just as they should 100% Flash sites. Too often small business owners are taken in by bells and whistles and miss the boat entirely on the fact that you have to be found on the web first before the customer can view your site and products. You can have an exceptional looking site that gets results without having to resort to a full CMS dynamic site. Buyer beware.