I just stayed in a single cabin on the NS and loved it. Yes, it's a bit of a walk to anything aft on the ship, but I was pleasantly surprised at how spacious my cabin was!
There was a bit of noise one night during some rough seas. Something must have been loose and knocking about outside, but otherwise it was very quiet and extremely comfortable, especially the full sized bed.