It largely depends on how you define “worth it.”
If you’re doing strictly a dollars and cents calculation, such as: will you be able to get enough food and drink out of the lounge to break even? For most people the answer is no. Similar to how a first class ticket on a plane comes with a meal, a cookie, alcohol, a nice seat, and warm nuts, the value of those things won’t make sense for most people.
Assuming club level is $150+ per day more than your standard room, you’re getting some decent snacks, drinks, and maybe save a bit on food elsewhere (not that the food is so good that you’ll want to cut your touring plans to head back to your hotel all the time, even if it’s conveniently located). You might be able to make a meal out of the early evening food. But like the first class seat on an airplane, most of the benefits won’t be practical — they’ll be intangible luxuries.
You‘ll have a nicer room than your standard room, with a better view. You‘ll have access to cast members who will go out of their way to help you with concierge requests. You’ll get fireworks music piped into the lounge and a beautiful view in some cases. You’ll have the joy of taking a cheese plate back to your own room and sitting on your balcony. You’ll have a little escape from the crowds in a private space. In that sense, as much as vacation is a luxury, many people do find it worth it.