There are so many contributed modules that can help build things out, but I always need some type of customizations requiring (usually a few) custom modules per project. It all depends... I did one project that had dozens of crazy features that we broke out into 70+ custom modules...
But yea, I would say the sweet spot is a customer who needs a pretty large site with a lot of functionality. My 2 cents anyway.