From Brown Dwarfs To Super-Earths: An Observational Study Of Weather And Atmospheric Composition