Many investors see portfolio diversification as an almost magical strategy that reduces risk and ensures solid returns, but actually harmful in extreme doses.