yeah, I can say that except for elder areas (not necessarily dedicated facilities, but there are things like "RV parks" which cater mostly to older folks but also families; they usually have 10mph speed limits), I've never seen someone driving a golf cart around town while I've lived in MI, OH, or PA.
I do see people driving horse-drawn carriages, ATVs (probably illegally), snowmobiles (legally in some parts of MI during Winter or condition-dependent), and riding mowers (probably illegally) in and around towns, though. Very rarely, I see someone driving an e-bike; this rareness is mostly because they aren't allowed on the sidewalks here and there's no bike lane, so you need to drive and signal like a car, which is pretty awkward given how many e-bikes don't even come with real brake lights (though many falsely advertise red rear running lights as a brake light, which'd be illegal to drive unless you hand-signal whenever you brake).
Coronado Island, near San Diego, California, for one.
Sun City, Arizona, though these are golf communities/mega-master-planned communities. Coronado is a better example of a mixed vehicle environment with golf carts bopping around all the time on the same streets.
Coronado isn't a good example. Or at least not one that scales, that's a VERY affluent neighborhood.
The golf cart isn't a replacement for a car, it's one you have on the side. I would argue that its partially because they're easier to park in a very touristy environment