The best methodology will strongly depend on the combination of Project goals + Workplace Culture + team knowledge + organizational maturity level. The most important point when choosing a methodology is a way to achieve goals, not the goal itself.
Forget about the old battle Waterfall x Agile x Hybrid – focus on change management, communication, simplicity and smart goals.