In modern times, the Volkswagen XL1 approached the aesthetic. It had an equally low coefficient of drag as the aptera. Not many sold - but it was a production car.
https://www.autocar.co.uk/car-review/volkswagen/xl1/first-dr...
https://www.autocar.co.uk/car-review/volkswagen/xl1/first-dr...
XL1 is an interesting 'what-if' of cars. If VW doesn't get caught cheating on emissions we would likely have gotten some kind of successor to the XL1 that was actually truly a production car. Certainly VW would have at least tried a few production diesel hybrids. Instead they became the first large established automaker to fully commit to a battery-electric future.