I personally like the balconies on deck 9 on the voyager class ships. I have found them to be quiet, but also convenient to get to places around the ship. We have had several balconies between 9302 and 8286 and had good luck.
Some of the quietness though depends on the other passengers that week. Get a few kids down the hall running and you will hear it. So the only way to minimize traffic by your door is to book a cabin far aft or forward.