Funnily I don't think I've heard Waterloo used that often, in French.
Berezina is more commonly heard as a "complete and utter fuck up of epic proportions". It's the most memorable defeat in the entire retreat from Russia, which itself was a complete disaster.

Waterloo was more of a swansong, since Napoléon had just come back to power after having abdicated, and he was hoping to prove he still had it. He did not.