We've been fairly close to the elevators and it never bothered us as all. Once we were right under the pool deck and could hear tables and chairs being moved around, nothing that annoying, so I don't think you will have a major noise problem, seems once you close your cabin door, you don't hear a whole lot.
We were on the Explorer last month with a cabin on the other side of the elevator wall and didn't hear a thing. In fact I just realized we were that close after seeing this post and looking at the ship's layout again. Marnie and Pamda are right when they say it's a good landmark and also convenient.