Investor enthusiasm culminated in some of the worst cases of wealth destruction in the last 100 years, a long-running study shows.