I currently have 4 optical drives, all PATA versions
All but 1 are currently running on SiliconImage SATA > PATA adaptors without any problems at all.
If you do buy a SATA only motherbord then there are options to allow you to still use PATA drives (well, almost all drives except for my BenQ DW1655, this just will not work on a bridge board)
Saying this however, if you have a supported chipset and motherboard and SATA drives are within your budget then go for it. Remember as a general rule the SATA port must not be part of a raid system for the drive to work.