Computer room air conditioning (CRAC) units with the latest technologies, compact footprint, versatile configurations, and high efficiency which are available in direct expansion, free cooling and/or water source