So, I've recently run into a similar situation personally. I realized I need to update my HTML knowledge, as it's nowhere HTML5, CSS, etc. ready. At the same time, I have young kids who want to learn more about websites.
We started using the tutorial at internetingishard.com and have loved it. It's approachable enough that my 10yr old and 7yr old can follow along and participate, and I'm learning what I need. So, I'd add that to your list. It may be more 'basic' so as to help wet the appetite and creativity for your designer types.
We also have web content managers in a similar situation where they aren't comfortable using anything besides WYSYWIG. We've also been unable to find a CMS that meets all the requirements we have and has a great WYSYWIG. So far, they've enjoyed the little bit they've tried with internetingishard.com