This is perfect Ryan, just the type of response I was hoping to find. My website is a database driven website and my opinion has been that the platform does not have nearly as much influence (if any) on organic rankings as the SEO working on the site.
In most every case where I've found an SEO related issue in a open source cms someone else has experienced it too and has already built a solution...and if it's new technology, like you said, an extension is usually soon to follow. The main concern I had and criticism I am trying to refute is that "because my site is built in drupal, it cannot/will not ever perform as well as a static HTML non-dynamic site"
I think your response helped answer this question, but I'd always be interested in additional feedback and other SEOMoz opinions on this matter. I was going to start my own post on this topic, but it seemed to fit so well with this ongoing discussion.
Thanks