"Diff'rent strokes for diff'rent folks"
I share some of the concern of the original poster. Several years ago, we cruised from L.A. to Hawaii on the Celebrity Infinity when it was just a few weeks old. The ship was spectacular, there was plenty to do (or nothing to do, if you preferred), but we were more than ready to go ashore in Hawaii after just four full days at sea.
Based on that experience, we realized that longer ocean voyages are not our favorite cup of tea, at least at this point.
I know that some folks enjoy traveling on freighters (cargo ships) that are at sea for many days at a time. I might possibly enjoy that someday, but right now two or three days at sea at a time are more than sufficient.
Come to think of it, I was on a destroyer in the Navy when I was young and we were sometimes at sea for 10 or so days at a time. I remember the incredible monotony of standing watch four hours at a time, especially the midnight to 4 am shift. Never again! (smile)