I have been on two cruises. Both were fun. Of course, I paid for neither (family cruise on my parents dime for all of us), so that helped. But I enjoyed both cruises. The first was a larger Carnival ship I believe. This was back around 2004ish. Kids were quite young then, both mine and my brothers, so of course with kids it changes the equation. That said, there was a lot of stuff the cruise had for kids where you could leave them attended for several hours.
The 2nd cruise was also a family cruise, but just adults. It was on what is now the 2nd largest cruise ship.... something of the Seas. I enjoyed it. There's a ton to do, I enjoyed the pretty high end Vegas type of shows. The day stops were all good. We did get the drink package on that cruise and used the hell of out it.
I enjoy all you can eat formal dinners. You want another lobster and/or prime rib? Yeah, bring me a 4th, please. This cruise was in Jan of 2020, right before anyone knew what covid was - got lucky we missed that Covid lockdown window by like a month or two. Never got sick on either cruise.
All that being said, if those two cruises weren't paid for I probably wouldn't have gone. My parents have been on at least one cruise per winter for at least 30 years (probably longer than that honestly). Often two cruises a winter, sometimes they have even done 3. They love it. They have also travelled pretty much the entire world. The missed their China trip 6 years ago or so when my grandmother was quite ill (she is still kicking, will be 100 in early Feb of next year), and at this point China is out for them. They often align cruises with longer trips - like a Med cruise along with a Europe trip.