What type of Paprika is the generic stuff one buys at a grocery store chain? I have read this very good link on the differences in paprika, but I did not learn all that I need to learn as far as buying these different varieties.  When I go to my grocery chain to do my weekly shopping and I see the spice container which says Paprika, is that just going to be "Plain" paprika.  I ask because I need to go out and find both sweet paprika and hot paprika which probably will require a little more effort on my part to find.  Maybe a Whole Foods or something?
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)