The individual, the weather definitely play's a part, the deck height and location all play a part in it and it is very very subjectional.
No one person can say what is right for another.
The laws of physics dictate that Midships and low down is best for less movement in rough seas, but some feel better with fresh outside air, so a higher up balcony Stateroom is better for them. Some just need to see the horizon so a lower down Ocean View Stateroom is enough. Some have a problem with the vibration of the prop's so lower down and Aft isn't for them. Some people have a problem with side to side rocking, other's up and down.
It really does all depend on the individual, location and weather!
Ex Techie