A lot of people where I work have one and never stand up at it. I think you should try to find a way to try one for a week or so and see just how often you actually use it standing up.
If you see one person buy something then not use it, that's a fact, but if you see a lot of people do the same then it is a pattern. If there is a common pattern of people buying "betterment" products then not using them, you should evaluate why you won't be yet another statistic.
I use my standing desk for reference, but the larger point is that a lot of people buy them and then don't use them for whatever reason. Likely don't think through what they're trying to solve and how often throughout the day they think: "wish I was standing right now."
This issue is a reason why you should buy the cheap version of whatever it is first, then upgrade when you out-use the cheap one, rather than going all in on those $500 shoes or that $1500 exercise bike. Applied to standing desks: Try a "Standing Desk Converter" or a cheap IKEA standing desk for $300 instead of a high end motorized one for $1K+.
Yet a bad guitar will turn off a lot of people who would have kept playing if they had a better quality instrument.
My advice to the OP is to buy something used at a decent price. Chances are that if you don't like it after a month or so, you can sell it for close to what you paid. And if you like it so much after a month or two that you want to upgrade, you can sell it for close to what you paid.
If I could have found a good ergonomic chair that elevated to standing desk height, I would have loved to continue using it. At the time there were drafting chairs, and task chairs or task stools that would have been at the right height, but nothing really comfortable or ergonomic. Wonder if that's changed now.
They encouraged the OP to test it out if possible before committing to ensure they would actually use it in practice.