I have a 2007 2.0 SE and find it great. Its excellent from A-B everyday but then when you get on some twistys its awesome, for a modern car its so much fun and feels like my little mk1 mr2 when you start throwing it around.
Insurance was the only reason i went for the 2.0 SE, couldnt justify paying the extra £300 a year for a sport or £500+ for a 3.0si plus my budget was only £13.5k. The only thing i would change apart from the engine on mine would be the seats to sport bucket seats.
I also drove a 2007 2.0 sport MX-5 when looking at my Z4, it was nice but felt cramped, the engine is noisey, manual soft top which is noiser then the Z4 at high speeds, the rider is harsher, heavier steering and put them next to each other in a carpark there was no contest.