I had a go with some expensive Bose ones and although they cut out some noise I could still hear loads of stuff, I couldn’t see what all the fuss was about
I’ve got the QC35s and, while you still hear some noise, they cancel enough that you can tune the rest out yourself. I work in an office with some very noisy project managers who yap a lot on the phone and used to get very distracted by their conversations when I was using non-noise cancelling headphones. Since I got the Bose I don’t notice them unless I’m trying to, would thoroughly recommend them.
They’re also great for flights/trains – you don’t really notice how much background drone there is until you turn the noise cancelling off!
They are spendy, but I could justify it as I use them pretty much every day and haven’t regretted it for a second. The wired QCs might be a good option if you can get them close to your budget.