We've waited years to drive Nissan's new Rogue Sport crossover to see if it's worth $27,000 — here's the verdict