I disagree the Rogue is 'generic'. Perhaps the the 'baby Murano' look... and Muranos are fairly common now. If anything, the new Murano got a similar taillight treatment so now they really are indistinguishable.
As for cargo space, although the rear hatch is more rounded you can still fit a fair bit of gear. I do agree that Nissan sacrificed some utility for the sake of styling. But I think they got many things right. The 2nd gen 2.5L motor in the Rogue is far smoother than it used to be (I had an '03 Altima previously), and the CVT does work very well.
I use mine for work everyday and haul just about everything: tools, material, and my weekend play stuff... mountain bikes, canoe, trailer. It's been great and is far more flexible/useful than my Altima ever was.
As for fuel economy, with a light foot it is very easy to achieve 8l/100km. That is just a tick off what my '03 Altima got (same 2,5L motor, 5spd manual). Drive agressively though, and the CVT will keep the rpms high and the fuel economy plummets quickly.