Very few times since the cruise ship captains do a great job taking care of the passengers but of course, it's a ship at sea and weather happens.
I was career Navy and to be weirdly honest I actually enjoy rougher weather at sea. I sleep like a baby. 🙂
Welcome to CC. Recommend that you ask/research on the Aruba forum. Lots of great info available to peruse. Here is the link for you:
https://boards.cruisecritic.com/forum/101-aruba/
Not sure what you are talking about specifically but have you looked at the Ports of Call section here on CC? There are sub-forums for just about every port available with lots of great info.