Very new Roadster driver here, but I daily-drove a 500e for a year, and a Lotus Elise for 8 years before that. I just went through the same decision process (Roadster vs. 500e+Evora vs. C7 vs. Cayman vs. Jag Type-F, all roughly in the same price range). I chose the Roadster because it was the funnest to drive (well, second funnest - the Evora S was insanely fun), but for me the 0-60 was less important than the dynamics.
That being said, I do have Roadster Anxiety (to coin a phrase): I'm worried that any one of the insanely expensive bits of my used car will stop working. I only have the non-battery warranty, so I find myself obsessively checking my batteries condition, making sure it cools down quickly, etc. Maybe that'll wear off after a few months, but at this point it doesn't feel as care-free as driving the Elise, or the 500e (which was a lease).
Another thing: compared to the 500e, the Roadster feels very much like a prototype. The 500e is plug-n-go. The Roadster is always cooling the battery, warming the battery, making strange sounds in the middle of the drive (keeping the battery in temp range), making you think about charging amps and cycles. The 500e does a lot of this too, but it manages to hide it well. On the other hand, this kind of thing appeals to me. My biggest issue with the 500e was that it was completely un-tweakable; the manual didn't even explain what the jack points were. The Roadster is a tweaker: I can play with the diag menu, OVMS, suspension, etc, etc, etc. The only thing I miss is digging around the just-drain warm oil looking for shavings (ok, I only miss that a little bit).