>Rental scooters/bikes cover last mile service very well in my experience.

Not so great for family trips, shopping around, etc.

Those (rare) occasions are when you rent a car. You can do it many times per year before it becomes a financially worse option.