While the smoked variant is the responsible ingredient for the smoky flavor in many recipes, sweet paprika gives your dishes a fruity, sweet and slightly bitter flavor with very little to no heat at all. If you happen to spot the usual bottle that just says paprika, that’s most likely the regular or sweet variant.
Think of capsaicin as a powerful defence mechanism plants have developed to survive. The key about capsaicin is that it does not affect all species of animals or fungi. This is a brilliant evolutionary development that makes the existence of capsaicin twice as beneficial to the plant.