I have never had a bad cabin. The only cabin I hated was an inside cabin and that was for the claustrophobia and inside cabin psychosis I had after being in it for fourteen days.
I have had balcony cabins under the Lido deck and while there was noise around 6 a.m. and 7 p.m. it was otherwise fine. I had read reviews by people in the same cabin and they said it was TERRIBLE. I guess it's all in your tolerance.
My preference is an aft balcony cabin. Nothing better than staring at the wake on a moonlit night.