I’ve seen drupal routinely implemented for larger clients, along with ezpublish and typo 3 at a previous job (i designed templates for these). The fact those were large projects that required multiple devs to implement led me to believe those were not a good fit for smaller projects/clients/personal sites.
Yeah, it's weird. All the modules (plugins) are free and open source as well so it looks like a no brainer. It probably has something to do with the steep learning curve which can be intimidating.