I guess I'm assuming quite a lot about your question when I answer. If you're asking if any generic, i.e. Windows PC-geared PCI ATA cards, my experience is that they don't work at all. As far as I can work it out, you need a Mac-ROM-flashed card in order to have functionality on Old World ROM Macintosh machines. (pre-blue-and-white-G3) I've tried several generic PCI IDE/ATA cards in my PCI Macs and I haven't gotten any to register in 7.6.1-9.1
Your mileage may vary, but were it me, I wouldn't buy a generic card and hope it works. At least, I wouldn't do it again.
If it's already a Mac-ROM card, you should be golden. The holdup will likely be which version of Apple CD-ROM extension you have installed.