In my experience, people matter more than methodologies. If you have good people on your team, product and dev, then you can make any methodology work. If you have bad people, no methodology will work. Advocating for one methodology or the other is far less important than hiring the right people.

That said I prefer Agile to Waterfall by a lot, and Agile developed in reaction to Waterfall so I think it was a success.