Accidentally grabbed the cayenne instead of paprika once for a recipe I was following. Ended up being an improvement, though have gone to mixing them each 50% since then for the best results.
I really like paprika, but it's easy for other flavors to overpower it. A lot of recipes that call for it don't really need it in my experience, because I can't taste it at the end.