We took the plunge 5/6 years ago to go electric for our second car, and this is where I think the sweet spot lies.
The pick ups / drop offs, the grocery shops, trips to places within about an hour of home etc, this is how it's used. Turns out it covers 80% of our our driving needs, meaning we're nearly always in it. Our 'first' car has been relegated to 'second' place & because we charge at home, in the 7500 km we travelled last year, the total 'fuel' bill was less than €200. Make no mistake though, an EV works for us because there's an alternative when we need it. We don't do cross country trips in it, we don't use public chargers, we don't have range anxiety to deal with. In other words, all the benefits without the drawbacks & I'd recommend one to anybody in the same boat.
Final point, and mainly because this isn't mentioned often enough, the best part of EV ownership isn't how cheap it is to run... it's how silent and stress-free it is to drive (if you ask my wife), and it's how much fun all that instant torque is (if you ask me!). When either of us have the choice, it's the EV which gets taken every time, for its driving pleasure.