If you prefer a manual transmission because of its efficiency, you should consider getting a CVT if you like driving it. The CVT will likely deliver better fuel economy than you could on a manual transmission.
If you prefer a manual transmission because it is cheaper to maintain, repair, and replace than most automatics (including CVTs), you should hold out for a manual transmission.
If you prefer a manual transmission because it is more simple (mechanically, and therefore more reliable) than an automatic, you should hold out for a manual transmission.
A CVT is more efficient than either a manual or a traditional automatic transmission because rather than fixed gears, it has a gear system that is constantly looking for the most efficient gear ratio. The only downsides to CVTs are that some people don’t like how they drive and they often can’t be repaired if they break, only replaced. The CVTs I’ve used in fleet vehicles (one Camry hybrid and one Prius) have been reliable and easy to drive.
Owning a CVT instead of a manual might be a good reason to consider an extended warranty, especially if your Civic also comes with variable timing (Honda’s VTEC).