I've gone through the steps of setting up and configuring several smaller Drupal sites, both 4.6, 4.7 and one 4.6 that I upgraded to 4.7. Two are live, public-facing sites with happy customers although they are somewhat modest in scale. I'm also a huge fan of VB Drupal. I'm hoping to deploy something larger scale within the next couple of months.
The biggest problems I've had with Drupal is lack of CRM and core IT features such as email which is hardly Drupal's fault. The biggest frustration for me was learning how to architect a good taxonomy, but on the plus side that does NOT affect the end-user's experience of the site, once it's structured the way you want it. Overall, coming from someoone who has dabbled most of the other CMS platforms out there, this one is highly recommended.