Even those who would be deemed "responsible" (already somewhat wealthy, otherwise stable) often end up far worse off.
It often ends in losing friendships, ties with family, death/kidnapping/blackmail threats both close and far away, endless frivolous lawsuits, financial ruin, etc.
The ratio of "happily ever after" stories to horror stories for winning the lottery seems a bit low for my tastes.