I'm the same as you. I enjoy cruising on the smaller, usually older, ships. There's plenty to do on board, usually great food and many dining options and it's a great way to see numerous places in a matter of a few days. I went on a Royal Caribbean 'Mega Ship' once. Never again. Too many people & too much constant noise.I went on a Caribbean cruise once a yr, 8 of them, until my lady cruise buddy died 20 months ago. Most were 3,000 passenger size, all Princess. I'd never go on this new thing.
It's interesting though that building these monstrosities seems to be the direction ship building is going now. There must be millions of people who enjoy going on these mega ships. They wouldn't be building them otherwise.