It depends on how bad their behavior was and how much I like their work. Im thinking of examples:
Pedophilia - Polanski
Racism/inciting violence - Ted Nugent
Infidelity - Picasso
Addiction/general jerkiness - RD Jr
I dislike all the above though. I don't think I could ignore the first two indiscretions. The second two, maybe.