In what ways do modern geotechnical engineering practices address the challenges posed by different soil types and ground conditions when planning and executing large-scale construction projects, and what methods are most effective for ensuring foundation stability?