I add cayenne pepper to sauces all the time. I heat the sauce up in a sauce pan, and simmer for 15-20 minutes, to cook the cayenne into the sauce. Adding cayenne to cold sauce will require extra time for the pepper powder to fully incorporate.
I like to add cayenne and honey to commercial BBQ sauces. I like a good blend of sweet and heat.