You will be able to use any SCSI controller out on the market I believe, but if the interface doesn't match you will need an adaptor of course. If you can't find a drive with 50 pins interface that suit your needs, find a 68 pins one that will. Put in an adaptor, and away you go.
As for CD burning software; try MakeCD, that's the one I use myself, but there is a program called Frying Pan out there, which I have heard should be pretty good as well.