I think this depends too much on your car and how you use it to make generalizations like "is usually overkill".
With an 11kW charger and assuming 12h in the garage, I can charge 132kWh in a day, which is far more energy than my battery can store. Thanks to this, when I park my car and decide whether to plug it in, all I need to think about is whether the car has enough charge now for my needs tomorrow. If it does, I leave it. If it doesn't, I plug it in.
With a 1.8kW charger, I'd only get 21.6kWh overnight. In my car, this is ~100km of range (~60mi) and about 30% of the battery. Now I either need to charge it every day (and add the hassle of unplugging/plugging every time I use the car) or I need to think about it more.
It's a matter of individual preference whether it's worth a few hundred dollars to avoid that friction but to me it's more than worth it for something that's part of my daily life.