I've really enjoyed seeing these makeovers and I've always found it fun to give makeovers to the townies so I thought I'd show a couple. I'll start out with one that I feel was mediocre and then one that I kinda like.
Pansy Northrop - Before

After

Not the best, but, in my defense, I haven't played around with CAS much. (I've only been playing TS3 since last April)
Now this next one I actually kinda like. It's just a random townie that married my sim's aunt or cousin or something (there's way too much family to keep track of.)
Before

After

Believe it or not I actually didn't do much. I had him drop some pounds and added a custom skin and he was looking pretty nice already, so the facial tweaks were actually rather minor.