I had a 2007-8 Rogue for close to 4 years, and used 5w30 and 5w-20, valvoline synpower and Pennzoil platinum.
I have done used oil analysis on these oils, so you can find them in the used oil analysis section to give you an idea, and decide from there.
Yes, the engine is noisy, very noisy when very cold, but there was nothing special to say about it in the used oil analysis.
I did one year OCIs and I am easy on my cars.
Hope this helps.