Towards a molecular level understanding of chemical and physical phenomena in metal-organic frameworks