Here are a few that come to mind:

1. Michael Bolton joining Black Sabbath

2. Slash joining Poison

3. Slash joining Megadeth

4. Zakk Wylde joining Guns N' Roses

5. Dave Navarro joining Guns N' Roses