There's a Samsung drive that has a firmware update for Mac OS X that will allow auto-sleep. It will also work with other models using the same chipset.
Also, you can try to find HL-DT-ST DVDRW GS21N that's the one that Mac Pro ships with.
It will probably be OEM to LG, LiteOn, or Hitatchi.