Well, I think I may have found what was causing all the noise with my
superdrive. I pulled the cover on the MacPro then, pulled out the 'cage'
that holds the drive(s). (This thing is a joy to work on). The drive has
a 'bezel' (some might call a trim piece) on the front. In the old days, this
part would be seen as the front of the drive on PC's in years past. The
bezel snaps onto the housing of the drive itself. My bezel has some
play in it and when the drive spins up and vibrates, that play was allowing
the bezel to vibrate and produce that annoying noise.
I had the choice of removing the bezel permanently or 'shimming' the
bezel to remove the play. As the bezel seems to provide some protection
(however minimal) from dust, I chose to shim the bezel.
For now, using the drive is a very pleasant experience after listening
to that racket for so long
EDIT:
I also have a MacBook Pro and its never made the kind of noise my Mac Pro used to.