Donor-Acceptor Dichotomy in Novel Schiff Bases: Comprehensive Spectroscopic and DFT Investigation of Intramolecular Hydrogen Bonding and Charge-Transfer Properties