There are bootable SATA cards, there’s a thread on here somewhere (mind my laziness, I’m on mobile and I’d have to search) based on the SIL3112 and 3114 chipset, but I’m fairly certain those are SATA I and don’t have any RAID support.
Other than that I have not seen a card that fits your description. Hopefully someone else can bring better news.