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+.
It's a shame IKEA doesn't make the Jerker desk anymore. I have one, and it's probably the greatest desk ever made. You can configure it as a standing desk by unbolting and repositioning the desk on the legs.
I had the jerker desk for a long time, before standing desks were really popular. It was a fantastic desk and I loved using it in the standing position.
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.
This might feel logical but i find it counter intuitive. I've seen people suggest to new guitar player to just buy a cheap one just to see how you feel then invest in a good one.
Yet a bad guitar will turn off a lot of people who would have kept playing if they had a better quality instrument.
Counterpoint - I know plenty of people who go out and buy an expensive guitar (or camera, or bicycle, or <name your hobby equipment>) and it sits around when they discover they don't want to put the time into it.
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.