When are you going? We just got back from the Eastern Caribbean route and there is a good amount of weather stirring up the water out there. Captain steered clear of it by day, and our shore excursion were never interrupted but you could see the storms in the distance and watch the lightening at night.
Good chance you will feel the motion. Mostly a gentle rocking that lulls you to sleep at night but some occasional periods of time that makes walking a bit wobbly.
If you are concerned about motion and noise, the best place for you is on the Riviera deck, in the center of the ship. It offers a lowered center of gravity. You will only have other staterooms above you which should minimize noise and by being low and in the middle, motion will be much less noticeable than higher up on the ship. Many people have a snobbery with regard to the Riviera Deck, but truthfully it is the best place to get a good nights sleep as it is completely dark and generally very quiet. If you are sensitive to motion sickness, I would avoid balcony's and suites which are always on the outside of the ship and generally much higher than the Riviera deck.