Molecular Absorption Effect: A Double-edged Sword of Terahertz Communications