I have a stash of both types from my inlaws last trip to Hungary. True "hot" paprika does pack some decent heat (think jalepeno hot).
As for the use in rubs, I definitely think its just a filler for most rubs. After a long cook there really isn't much flavour left. That said, I do use it...