Tightly Confined Surface Acoustic Waves as Microwave-to-Optical Transduction Platforms in the Quantum Regime