The Honda CR-Z MANUAL is a pretty fun car to drive. Handles well, not much power but its enough power to have fun in the twisties. If you are thinking about the automatic then forget about the car.
I do not recommend modding the power train, it is fine as it is for daily drives, for highways, for pretty much everything you want it to do except racing. I mean, don't go racing against a Perodua Myvi 1.5L or a Proton XC70. If you want to do that buy something else.
It's not that common, plus it is quite cool. My experience is 18 months between 2016 to 2018 on a 1st hand Gen 1 Honda Malaysia car, not much problems at all. If you want a sporty 2 door coupe, fun, and have good fuel consumption, highly recommended.