I have a pair of QC35's (v2, I think). They're OK. I'm in the Apple ecosystem and decided to try them with the idea of returning them if I didn't like them.
The NC isn't hugely better, but the transparent mode is kickass. I use it all the time.
I think they are overpriced, but after more than a year with them I'm happy I have them.
Note that they were really tight when I got them and I saw a post on reddit about bending the top bar to make them looser. Before doing it I couldn't wear them more than an hour at a time. Now I can wear them all day.
I have a bias against Sony, for many reasons (over the years), though I have no doubt their headphones are really good, too.