I have the Sennheiser Momentum 4 headphones. They double as a phone headset. They cancel noise well. The winners, I hear, are the Sony WH1000XM5 headset. But the Sennheisers have better sound and are just a tiny step down on noise canceling.
They have a transparency setting from pretty open to seal your ears quiet. If you play any kind of music or audio through them while canceling noise, you likely won't hear the house fall down. You might hear it through bone conduction, however.