I've got a 2006 Micra C+C and find it a very reliable and economical car.
The C+C is the coupe convertable version so it looks quite sporty but without a big uneconomical engine. As a small car I find the 1.4 engine size perfectly good and nippy enough to be away at lights etc quite rapidly.
The C+C does have a very large boot where the roof folds into if you have the roof down. When the roof is up though it provides an above average amount of boot storage. It is actually a much bigger boot than a standard Micra.
The compromise on space with the C+C is the back seats which are small and really only suitable for children if on journeys of more than 15 minutes or so.
New Micras often come with a 3 year finance deal which can also include 1 years free insurance, RAC membership and prepayment of annual services. This 3 year deal can actually work out as a very cost effective way of covering these costs.