Hybrid Terahertz Metamaterials: From Perfect Absorption to Superconducting Plasmonics