Hello npereira,
The non-BOSE systems do not have any connectivity options aside from the line-in jack on the front. Your only option is to replace the desk with an aftermarket unit if you want more features.
The BOSE systems have a proprietary bus connector that allows iPod and Sat Radio connections. To get these options, you need a special adapters/receivers from Nissan... and they are not cheap.
IMHO, your best option is an aftermarket deck. Fortunately adapter plates are available that allow for single or dual DIN deck sizes as well as adapters for the wiring. With these parts, you can fit just about any audio deck on the market!
My best suggestion is to browse our audio forums:
zeroforum?id=99
While there may not be anything Rogue specific, most of the headunits/decks can be used in the Rogue.
As for a suggestion? My personal bias is towards Clarion. The CX609 is a double DIN headunit that has Bluetooth, SAT radio, direct iPod connectivity/control, and MP3 playback from CD and memory stick (USB). Most importantly for me, it has large easy to use controls.... one of my pet peeves of the 'fancy' head units that are so common. My wife has the next model down the DUX385SAT and it has been a great head unit. If I were to swap the one in my Rogue, I would use either of these units.