I agree it has gotten better on many fronts since the old days but plenty of my old reservations against drupal still (surprisingly, I expected those would be major focal points for improvement) hold today.
> It's got to be something that a non programmer can build their project with.
That's a huge restriction, and in fact, if a non-programmer can build a project on a self hosted platform then you're essentially asking for trouble with respect to security and future maintenance. I don't really believe such a system could be made if it is at the same time required to be secure and reasonably scalable, unless it is hosted and kept up-to-date and secure by another party.
The fact that wordpress.com is raking in the money is an indication that for simple websites this is definitely a market opportunity, and given the frequency with which self-hosted wordpress sites get hacked the 'non programmer' restriction would seem to be the cause of a bit of a problem. It's like asking for a car that can be constructed by a non-mechanic.