I was wondering how good their noise cancelation would be for night-time sleeping, how effective would you say it is?

It's pretty good, but I guess it depends on your environment. Pretty decent at removing things like traffic, air conditioning, television. Even Sirens are pretty muted unless they are extremely close, which is a good thing I guess. They probably won't block the base beat if you sleep above a night club..