I drove a Honda S2000 for a little while (divorce present to myself) and it was 6 speed. I couldn't imagine driving a car like that with an automatic. Would have been incredibly boring.
friend of mine has one i've driven a few times. i bust on him a little about the miata like gayness when we're in it together but it's a fun drive.