Unless it says hot paprika or smokey, I would use the sweet one.
I use the sweet one for practically everything that needs paprika, and spice things up with chilli.