> Is our atmosphere more or less transparent to some parts of the frequency spectrum than others?

Yes. The frequencies that are not blocked are called "atmospheric windows". And there is indeed such a window for microwaves. These windows also exist for visible light and a range of IR, but those depend more on weather conditions.

https://glossary.ametsoc.org/wiki/Atmospheric_window