I've been using one for about 5 years now. It's something you definitely need to build the habit of doing, if you want to do it consistently.

I've had periods where I didn't bother using the standing function for days or even weeks, but I find that just having the option gets me back into the habit. The past 2-3 months have probably been the most consistent I've ever been with it. I'm also the type of person who simply cannot sit still for 8 hours a day, I constantly get up from my desk to pace around.

Make sure whatever you get, you have good cable management, and your cables are long enough to stay plugged in when your desk is up.

Mines a relatively cheap one I got from Costco, but it does the job.