The Physics of Terahertz Negative Photoconductivity in Low-Dimensional Materials