Addressing Electronic Complexity: Advances in Variational Monte Carlo Methods for Electronic Structure in Quantum Chemistry and Condensed Matter Physics