Exploring Ultracold Quantum Many-Body Systems With Multi-Layer Multi-Configurational Approaches