Most cruises do not have significant issues, in fact Caribbean and Bahamas cruises it's unlikely. Ask aka almost impossible, you do get it on longer cruises over oceans and say in Northern Europe.
The ship has stabilisers and can fill tanks either side to avoid movement.
So firstly it's unlikely,
Everyone agrees, very very forward, ( front) the worst, as it cuts into the waves.
The Aft, ( back) then us the worst,
Midship, mid deck is best.
Go back to " basic" science, the closer you are to something the more impact you get, the further away you are the least effect, as Scotty in Star Trek says, you cannot break the laws of science.
Lower decks, are 1/ closer to the waves, 2/ closer to the sea and current, 3/ closer to the engines 4/ Closer to the thrusters etc. So science shows the closer the more effect, the further distance you are the least. Lower decks get " random " small movements you cannot anticipate, Higher up its ironed out to a wave, - actually can aid sleep a gentle rocking.
Higher decks also have verandahs and a view of the horizon these help. Motion and seasickness is caused by the ear detecting movement but your eyes saying I see a wall and that doesn't move. Helping the brain out viewing the horizon helps, get fresh air and drink light, often sickness is more commonly cause by overindulge of drink and food then motion.
You will get someone defend deck 2 but until you sail in storms you do not know.
I have sailed in the back end if two hurricanes and last week a serve storm / rough seas out of Bergen, let me tell you cruisers responses, only say 20% turned up for dinner on deck 3/4, but cabanas deck 9 was full! In our cruise meets group of 150, deck two reported high sickness, and few going to normal dinner and waves over thier portholes causing concern. We noticed the seas but was OK on deck 8, it was a longer wave there, but didn't like staying down on deck 3 let alone two. In the theatre the performers had issues on the show. Deck 4 outside was closed in our storm, deck 9/10 were open.
My daughter who gets motion sickness us OK in our room higher up, not down lower, and the worst us little boats in Cozumel off the ship, that are low and enclosed.
Finally, most people use thier room at night, during the day a sea day most people are on the higher decks anyway, at the pools etc.
The movement if the ship can be different cruise to cruise, location, current, the direction of the ship to the current and waves, wind direction, the ballast in the tanks what tanks used to lower the ship in the water, the use of stabilisers etc. No day, or hour, or cruise us the same, so use the rule, midship, mid deck, the centre of everything, this us why those cabins are more expensive than others, as they are central and most desired.
Nose wise, avoid being under a bar, avoid being near a laundry, under a restaurant isn't too bad as thry close by 10.30 and open say 7 am,
