I think all "regular" paprika is sweet. If it is hot, it should say so on the container. There are lots of different kinds and some are really nice like the smoked ones from Spain. You can get them sweet as well as hot. As well as the Hungarian ones that are sweet or hot.
I doubt the paprika was the heat that bothered you. Try cutting down on the cayenne next time.