Despite its misleading name, sweet paprika, of which Hungarian paprika is one variety, isn't sugary or sweet at all. Instead, it's called sweet paprika to distinguish it from other types of paprika that are spicy. The end zing, or lack thereof, depends on what type of peppers were used to make the spice. Some paprika is made from red bell peppers, while other paprika is made from chili peppers. If you don't have sweet paprika on hand, you can use any number of substitutes, many of which will yield flavorful results.
In some cases, the paprika is being used primarily to add color to a dish, in which case you could add a small amount of some other red ingredient, which could be anything from a teaspoon of ketchup with a dash of chili powder mix to tomato sauce, finely pureed red peppers, tomato paste, or red beet powder. If you have bell pepper powder, use a 2:1 ratio, as the bell peppers are very sweet and don't have the kick of sweet paprika.
Bell peppers are rich in vitamin C, which is important for a healthy immune system. They also contain vitamin A, vitamin K, and folate. Bell peppers have some minerals like zinc, magnesium, phosphorus, potassium, calcium, and iron. They are also a good source of water and antioxidants.