Do it. You'll never regret it, promise.
If you're worried about it then buy a mk3 MR2 as a cheapy car to try. Mid-engined so a bit different, you won't get the gay label that an MX-5 (wrongly) comes with, and it's comfy enough with minimal rattles.
I wouldn't be without a convertible in my house, and the second the missus gets rid of her MR2 I'll have to seriously consider either getting a cheapy droptop or swapping the 911 for one without a roof.