They make all of the cars you want except for the electric Miata which would sell in such low quantities that it would have to be priced higher than the Taycan to be viable. Nobody's spending $180k on a Mazda.
You just don't want them.
I have a Fiat Spider for fun, and a Volvo V60 wagon for utility. My wife is 5'3" and is taller, barely, than the V60.
The Spider is dead and the Miata is dying because global sales have tanked and Mazda's only selling 6-8,000 per year in the US.
The V60 is dying because almost everyone who says they want a station wagon is lying, either outright or to themselves, and they buy a compact SUV instead. Commenters will shout in all caps on the internet that NOBODY MAKES A STATION WAGON ANYMORE, walk onto a Volvo lot, right past the V60 and drive off in an XC60.
I imagine the A4 Allroad (also a station wagon that doesn't exist!) is also on life support.
And before you go on about price, Mazda, Honda, and Toyota all sold inexpensive wagons in the US until past the point that it became financially negligent for them to do so anymore.
Nobody wanted them.
Consumers weren't tricked, brainwashed, hoodwinked, scammed, or flabbergasted-- customers did not want them so they didn't buy them so manufacturers stopped selling them-- in the US at least, you can still buy inexpensive wagons, with manual transmissions, all over the rest of the world.