What type of Paprika is the generic stuff one buys at a grocery store chain?
This information should be indicated on the label: sweet, sweet&amp;sour, spicy, smoked... 

Generic paprika is sweet and will probably not have much flavor (that is why paprika can be used in paella together with saffron - see this question)