Unraveling the Molecular Gas Conditions across Nearby Galaxies – New Insights from CO Isotopologue Emission Surveys