Spectroscopic Evidence for Competing Order-Induced Pseudogap Phenomena and Unconventional Low-Energy Excitations in High-TC Cuprate Superconductors