We also had an SS on the Westerdam last year, but we were near the aft elevators. Absolutely no noise from above. The staff usually re-arranges the lounges around 6pm, and even though we were in our cabin around that time getting dressed for dinner, we didn't hear a thing.
SS suites are wonderful, especially the bathroom - double sinks, 2 medicine cabinets, separate shower stall. I am sure you will love an SS.