Owners who have run both report the 5-speed is more than adequate and a bit calmer for daily driving, while the 6-speed is prized as a more engaging, torque-forward, value-adding upgrade on later NBs.
5-speed vs 6-speed transmission
Mazda MX-5 Miata (NB) · variant