If you find that the paprika or any spice you buy has very little flavor it can have more to do with age than the specific brand. If you don't use a spice frequently, then buy it in the smallest quantity you can find and use it up quickly. Bulk purchases of spice aren't less expensive if they sit on your shelf and lose flavor.
In my experience I usually describe Hungarian paprika as having a bit more of a slight tartness to it (basic sweet paprika, not spicy) and Spanish paprika has more of an earthy/woody/dusty flavor.
Ask a spaniard what they recommend and they'll say Spanish, ask a Hungarian and they'll of course be partial to their own. What I like very well may be different than your preference. The best thing to do is sample different ones side by side to see which you prefer and determine why.
Try Penzey's for high quality spices/herbs/seasonings. They sell in a broad range of packaging so you don't have to commit to a big container only to discover you don't like it. You may also want to visit the Spice House. They are separate branches of the same family and both do mail order.