Advancing Millimeter-Wave and Sub-THz Wireless Systems: A Holistic Approach to Physical Layer Design Optimization