SQL2005 still annoyed me, especially the full-text indexing as a separate process, very kludgy. SQL2008 is pretty sweet though, I love working with it.
We use these two databases to keep it simple and consistent. The web engineers know there databases well. We have over 100 web sites to keep running.