Definitely not the new CRX SiR, more of a CRX Hf.
Honestly best I can say is see if you can try one yourself, it's not very powerful but when you're actually driving one it feels good, fun to rev out and has the low down electric motor push to spin tyres. It's still more of a handling car than a power car, coming from a Miata I have no regrets, but coming from a more powerful car you may not like it.
It definitely makes tradeoff between power and econonomy, and for me using it as as daily it sits in a nice medium, but if you're just in it for performance there's probably better cars.
Even if you supercharged it (180-200hp safe) you probably coulda just bought a similar age Type-R for the same power with a similar or better handling chassis, even if you lose that short wheel base fun and good looks of the CR-Z.