What determines the kind of paprikas to use in recipes?

Spanish smoked paprika is powerful stuff that can enhance or overpower a dish. How do I judge when, how much, & type of paprikas (Spanish, Hungarian, sweet, hot, smoked, etc) to use?