A Mondeo or Celica is going to be so dull compared to a MX5 or MR2.
In terms of fun the mx5 was top out of the cars I mentioned (although the ST220 wasn't far off, the engine is fantastic) but it's just finding a good one now. Perhaps look for a late mk2.5, they look a bit better as well with stronger styling on the front (IMO).
Do some test drives OP, people like different things.