A lot of new cars are heading towards CVT’s, including Corolla mentioned above and the 4 cylinder Accord. The newer ones for Nissan had issues and they had to extend the warranty on them. One problem was use of regular ATF during service by shops. I think a lot of the issues have been addressed. I also believe that the Prius has a CVT with decent track record for reliability.
If you really love Nissan, you can test drive the newer ones and see if you like the manner the CVT drives. You should also research similar models from other manufactureres and weigh the pro/con. For me CVT goes in the con list but I think if I like everything else about the car, I might still buy it.