Yes, absolutely there are limits, and you have to weigh your personal investment and history with the friend and if it's something you even want to (or can) move on from if they change.

I don't know much about the Manson or Corgan stories, I was just responding to the question of 'well what happens when these people lose all their friends, is that going to help them learn and grow?'.