My optical drives started opening whenever I cold booted my machine just after I upgraded to Snow Leopard. I assumed the new OS was responsible, but it turns out that a change I made because of SL was the culprit.
Under Leopard, my Logitech wireless USB headset did not work for speech recognition. Since I only used the headset occasionally, I decided to leave the USB receiver unplugged when I wasn't using it. Snow Leopard has now made the headset more useful because speech recognition now works. So I opted to keep the USB receiver always plugged in. I didn't associate this change with the optical drives opening until it finally dawned on me that this is the only big change I had made recently. Sure enough, once I unplugged the USB receiver the optical drives ceased opening when I booted up.
I would, therefore, try unplugging all USB devices (except for your keyboard and mouse) and see if your drives stop opening when booting.