Would you rather have an automatic NA Miata or a stick shift 5th gen Civic coupe?

The core of the question is. With fun lightweight cars, or any car really, which is more important; the drive wheels or the transmission?