Flute is good in rock and roll songs.
Another instrument that really completes songs such as Comfortably Numb and If You Tolerate this Then Your Children Will be Next, Battery (maybe, it might be something else) is the cello. I think it is an amazing instrument, and think it should be used more.