Common origin of exotic properties in ceramic and hybrid negative thermal expansion materials