I never seriously considered the Rogue. The new one looks pretty good from the outside and, on paper, this is a great car.
It has a nice cabin with "Zero Gravity" seats, optional 3rd row seats, plenty of cargo space without it. The cargo area can be configured in multiple ways, including sliding the 2nd row seat, which is very useful for families. There are also air vents for the 2nd row.
On top of this, EPA fuel economy is best in class and it is a Top Safety Pick Plus. Pricing seems to be a tad lower than a comparable CR-V or RAV-4.
So, a practical vehicle from a well known brand, looks nice, potentially good front seats, lots of cargo utility, cost less and has best fuel economy and Top Safety Pick+. On paper, it is an excellent vehicle.
In practice, however, it is a combination of heavy + bit lower power + CVT + comfortable suspension that makes its handling below average. Nissan's CVT and reliability in general are below that of Honda/Toyota/Mazda. Actual fuel economy also comes in at 25 MPG, 3 below the expected EPA average. So, in practice, not very appealing.