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.