The noise cancellation is good for constant noises but not sudden ones.
This is kinda the nature of active noise cancellation, unfortunately. Blocking out sudden noise is just technically very challenging. Works great for airplane noise, not so much for crying babies.
Sony's XM line is in my opinion just about the best ANC headphones money can buy, in terms of noise cancelling and sound quality combo. I can understand your point about them getting sweaty. Part one of blocking noise is good sound insulation, which tends to hold in heat as well. I live in a colder climate so that works out well for me. You could get in-ear ones, although obviously they don't block out noise as well.