Got an S2000 back in March and I absolutely love it.
Car came from Honda dealership, so years warranty which was a bonus but being a Honda doubt I shall need it. 1 previous owner, they did major service, spark plugs, valve adjustment and had the rocker cover repainted red along with new disc brakes and pads all round, all in was around a grands work and I paid 14k for the car which had 49,000 miles on at time and was a 2008 which was the model year I wanted and feel is the best year to get as it has all the updates and tweaks done over the years but has the more dialled in setup from the earlier cars but without the draw backs.
I paid 14k and if I was to sell it today six months later I would be asking 16-17k based on market prices and even high if I left Ohlins on the car, in the USA similar cars are $25,000 plus if that is anything to go by what is happening over the pond, not saying UK cars will reach similar but you never know.
For me as a fun weekend car it does not get much better, they are bomb proof apart fromo alignment and bushes woes, only a real issue if your alignment is out however and they are easy to work on. Also look out for rust! Name on inside of arches and in the rear and front subframe area.
As a fun car, that is reliable and should not loose any money they are a good bet, I would not recommend one for daily use though, they are capable of it but roof up they lose a lot of their appeal for myself personally.
The other option and a car I am considering adding to the collection is a C3 Corvette as I'd like a classic but one that is not shall we say too classic, for a car of their age they drive remarkably well say compared to Mustang or Dodge of same era and the C3 was a bit unloved, C4 even more so and they have become really good bargains to buy and the prices seem to be strengthening, however they are LHD something to consider and the C3 is a classic car and around 40 years old so you will need to do work on it but they are very easy to work on, advantage of the C4 is its an old car but they are generally very reliable and drive even better. They all have the 5.7 V8 which sounds great, bit slow in the C3 as versions with cats made 170-220HP in a car weighing 1600KG, the C4 bumped the power and dropped weight quite a bit.
I'd not recommend an E60 M5 however as an investment, even if they do go up the amount of fuel you throw in it and the fact it will break and cost you money means any potential profits will be wiped out by running cost.
Good E46 M3 are still on the up!
Problem is most cars on the up have being doing so for 2-3 years now so a lot of increases have happened, the S2000 I paid 14k for, would have being around 10-12k a few years ago, but give it another 5-10 year and its fair to say it will no doubt fetch 20k plus if not too many miles were put on it, none of my cars are investment cars though, they all get driven and used as I buy them to enjoy and nnot for investment reasons.