Okay
BMW E30 325
BMW E36 328
Mazda MX-5
Honda CR-X 16v
Peugeot 205 GTI
Toyota MR-2 Mk1
Vauxhall Nova 2.0 16v
Renault Clio 16v
VW Golf GTI Mk2
Anything on that list will be great fun, even more so when you have removed the interior (trust me, even relatively refined cars are raucous when you take out all the carpets and interior fittings)
The BMW's are quite softly sprung as standard and will need a bit of bolstering to make them properly fun (soft RWD cars don't slide, they sort of bounce)
Manta could be a good outside bet but again on standard suspension they lean and wallow all over the place. You'll pick up a serviceable GTE for £500-£800, bombproof CIH boat anchor engine and it leaves you a few hundred to get it on some stiff Spax adjustables.
Sierra is always a cheap slidey option, get a late model 2.0 DOHC or a late XR4i, get it on the deck and as stiff as you can and it WILL slide. But they are not rocketships and are a bit cumbersome at times. Wealth of Cossie tuning bits, and LSD's etc available s/h which is a bonus.
Not a huge fan of the way the MR-2 drives for a RWD car (they never FEEL particularly RWD in my opinion) and so you might find it a little disappointing if getting the back end out and catching it again is one of your aims.
205 and Golf are both safe FWD bets, plenty out there to choose from, I think the 8v Golf is a bit dull compared to the 205 but some disagree. Golf is virtually nuke-proof. Clio is an outsider as they can be terminally unreliable but I think it's luck of the draw.
CRX is well worth a punt. No it isn't RWD but it's very raucous and very nimble and the engine is a peach. In fact I'd be tempted to choose this if you can cope with it being FWD.
MX-5 will likely be a rough old 1.6 at this end of the scale and whilst its one of the best chassis on the list, a knackered MX-5 will be nowhear near as nice as a half tidy 205 or CRX, RWD or not!
Avoid 200SX/turbo nutter things, they get tedious on track and can be expensive to put right.