From forex, stocks, to futures; I'm pretty sure majority of people who has ever traded, tried this at one point in their trading journey. Averaging down, reverse with doubling up, martingaling etc...it's so ingrained in us.
But lke you said, it doesn't always work. But it will work often enough...