Generally speaking, I agree with trekker, however both the stern and bow have their advantages, and disadvantages. I've had stern cabins where there was considerable noise from the props and associated machinery. As Trekker stated, the bow can be noisy in port, especially when the anchor is dropped, and retrieved, and the view generally isn't as good. (also the trek from the bow to the dining room, which is usually midships, or near the stern can be long, depending on the size of the ship). In any case, they can both be good, or not as good, depending on what you like, and which ship you're on.
See you aboard,