Horses for courses and that, but as little cars go I think Micras are fantastic. We had one that had done 160 000 when we sold it, and I still see it running around. I have never ever had to do any serious mechanical work on any of them that we've had, plenty of welding though... front crossmember/radiator support, back end of outer sills/inner arch/inner sills, rear footwells, front footwell/outrigger. Just general old jap car stuff really.
As for the CVT auto version, the boxes are a bit weak. I had one that was whining a bit by 40 000 miles, no idea how long they last because it got stolen and burnt out which kind of upset me because I was planning to either fit a manual box or break it. Also, the driving experience is a bit wierd if you are used to normal autos, but on the plus side they sap a lot less power than a conventional auto so in theory performance and economy isn't much different to that of a manual. All that applies to all CVTs, not just Micras.
To drive they are incredibly roomy and comfortable for such a small car. Of course they are never going to rival an Omega, but give me one over a Corsa, Fiesta, Ka, 106, Saxo etc any day of the week. 1.3s are suprisingly nippy too.
Great little cars, just check for rot.