Even if an electric motor is more efficient in creating mechanical energy than some ICE, the battery energy density is a fraction of what it needs to be to any kind of viable contender.
You're absolutely right, but we need to be careful how we present with those numbers. I'm not an engineer, and may have gotten something wrong, but as I understand, the specific energy of avgas is about 12,000 Wh/kg, while the best, just-being-released batteries right now can manage about 250 Wh/kg. That's a difference of 48× (more with the battery tech most widely-deployed right now).
However, the an internal combustion engine can use only about 25–30% of that energy, so the gap is more like 12× right now rather than 48×. That's a lot, still, but it puts battery tech two doublings ahead of where it would appear to be with a naive comparison. So if capacity doubles twice more over the next decade or two, batteries will be up to about 1/3 of the usable energy/weight of avgas, which still won't do for many aviation applications (like a cross-continent trip with 4 passengers), but opens up a lot more than we can manage now, and certainly isn't science fiction.
I have to say that the potential
some day (not soon) to fly around and do that sightseeing you mentioned on $5/hour worth of electricity rather than $50/hour worth of avgas is extremely tempting, as is the idea of not having a lot of expensive and frequently-broken parts to maintain (my plane is down right now waiting for welds in the carb air box and muffler, but there's also the mags, starter, alternator, plugs cylinders, valves, crankshaft, and on and on and on, as we all know from our shop invoices). I assume hourly-prorated battery-replacement cost will be comparable with pro-rated engine-overhaul cost, but we'll have to see about that part.