Love - love - love my Micra.
Paid just over £3000 for it in 2005, when it was 5 years old with about 24,000 miles on it. It has been completely, utterly reliable, and gets around 40 mpg. Found it in the local paper, bought it from a little old lady who was selling it to buy a new Micra, which she said she did every 5 years.
It's a manual -- you'd be surprised how quickly you get used to shifting with the left hand. And most cars here are stick shifts.
Micras seem to be very popular with my friends here in Scotland who need reliable transport, good mileage, and don't know much about fixing cars. My boyfriend just did the brakes for me and said it was an incredibly easy job.