What noise canceling headphones can block?

One of the greatest sources of stress in my life right now is noise. This is consistent with the (presently unconfirmed) hypothesis that I'm probably on the spectrum.

I live in a very noisy neighborhood, with many sources of loud music several days a week. I use a regular headphone to try to isolate myself, but they're not always effective. I was thinking of purchasing a noise canceling headphone (NCH). I'd listen mostly to podcasts and white noise. Hence the title question: can these headphones cancel variable non-regular noises like loud music around me? And to what degree?

Product recommendations are welcomed, with a focus on great noise canceling. I have a preference for over the ear headphones, but that's not a hard requirement. Other than that I don't have any requirements.

Thanks!