Here at Zemelo we just launched our biggest modx site to date. This in my opinion is a great example of how CMS can be about stunning design, as I really needed the flexibility of TVs and wayfinder to maintain the integrity of the design vision.
There are something like 7 different css based layouts displayed by using a TV to change the body class as needed, and fairly complex wayfinder menus that required lots of TVs to display in the various different divs and at various different levels - and most of the menus are sprite based so that the Frutiger typography that is so important to the brand is maintained throughout the site as much as possible. The blog section links off to to a separate IP running wordpress with a theme that matches the modx site. Many hours invested and the client was so happy he spiffed us a little extra for the effort:
http://weismandesigngroup.com
