Wet removal is still your best bet and hasn't changed much, but the key is doing it right: spray the ceiling with water mixed with a little fabric softener, let it soak for 15-20 minutes, then scrape. The softener helps it come off cleaner. If your popcorn was installed before the 80s there's a small chance it contains asbestos, so get it tested first - that changes everything and you'd need professionals. Assuming it's safe though, this DIY approach works, just expect it to be dusty, tedious, and time-consuming rather than expensive.
From a resale standpoint, smooth ceilings do help your house feel more modern and maintained, which matters for buyer psychology. Real estate folks will tell you removing popcorn adds more appeal than leaving it, especially in competitive markets. You're not getting back dollar-for-dollar what you spend on labor, but it's one of those things that removes a negative impression rather than adds value directly.
The mess part is real though. You're gonna have debris everywhere, drywall joint compound dust coating stuff, and if the popcorn flakes off unevenly you might end up with patching work. Some people rent scaffolding or use drywall stilts to make it easier on their back. If your ceiling is large or you don't want the headache, hiring someone to do it costs more upfront but saves a ton of aggravation. Either way, it's worth doing if you plan to sell in the next few years or just want the space to feel fresher.