I never got those cars. The only use case I could see was what you described: high density downtown living. They are small but that's it. They were not cheap. They were not efficient. They were not convenient in any way other than the footprint. And if you are living and driving in a downtown area where the small size is a benefit, there is a good chance walking or other public transit options are more available anyway.
They just seemed way too niche.
More importantly who is replacing Michael Wincott? "Kaw, Kaw! Bang! Fuck, I'm Dead!" Is going to be hard to match.