I know this is a debate that will never be resolved, but I disagree on the pricing. A "nice but nothing special" hotel room in many major cities will run upwards of $400. A "nice but nothing special" hotel room by a nice beach is easily $600+. And no one is waiting on you there.
Honestly, to truly be "waited on hand and foot", I would say you either have to: 1.) Travel abroad 2.) Be so wealthy that you hire attendants as part of your travel experience or 3.) Seek out niche experiences, like bed and breakfasts with exceptionally service oriented owners. I think that's partially a cultural thing in the US. Honestly, being waited on beyond, say, having an actual waiter at a restaurant kinda weirds me out. People I don't know hovering around for the sole purpose of paying attention to me sends me into introvert panic mode, lol. At some of the very nicest hotels in the US, a standard room means they will politely get you something if you contact them and ask for it, but the rest of the time they will take pains to stay out of your way (I think at some very nice hotels the staff literally have to duck into a doorway and hide if they see a guest walking by).
Regarding value of Disney resorts - I think it varies greatly. I think the moderates are actually an extremely good value. You get so much ambience, such elaborate theming, so many onsite recreation options, awesome cafeterias, and they're often less than the price of a Hilton in NYC or DC. There are a couple of obnoxious features - the exterior hotel doors and the "curtains as bathroom doors", but those aren't deal breakers. I haven't stayed at a value but the theming in those looks incredible. I think the deluxes are priced ridiculously with the exception of AK and FW. At least the post Covid rates were, they seem to be coming down a bit now. French Quarter at around $300 a night and Polynesian at around $1200 makes zero sense to me (if anyone is reading this and it made sense to you, more power to you, not a criticism). Polynesian is great but to me it just isn't four times nicer than French Quarter. The "upgrades" in amenities are honestly pretty minimal to my mind, and I actually think the lack of cafeterias is a downgrade.
I don't think I would do a resort only vacation at this point, as the resorts don't offer any kind of shows and pool hopping isn't an option. Ironically, I don't think I'd get my fill of Disney theming at Disney resorts only either. But I do think people traveling across various resorts and trying out different activities would find a lot to do. Carriage rides, pony rides, crafts, unique restaurants, jazz bars, shopping, places to watch the water parade right up close, that type of thing.