I dislike how other houses percieve Hufflepuffs to be weak or idiotic, perhaps it’s contributed to the fact that they were least fortunate when JK named the houses,.
Tonks was by no means weak or unable, she had as much brains as a Ravenclaw -she was an auror, she had as much courage and bravery as a Gryffindor however what made her a Hufflepuff was her values and her traits, she was Loyal, Modest, Fair, and Hardworking.
Cedric died trying to protect Harry, he showed both bravery and courage whilst attempting to protect his fellow student from what he thought was a lesser danger than Voldemort, however he tried, he was a seventh year with almost everything going right for him, close to becoming the Tri-Wizard champion.
Hufflepuff house gave the most help defending the school in the battle of Hogwarts -discluding Harry’s own house Gryffindor, JK herself said that Hufflepuff’s did not fight to be reckless or for ‘glory-lust’ they fought because they are Loyal, they are Just, and they did what they thought was right, no matter how many unnamed students or staff were lost.
Being a Hufflepuff does not make you Inferior to any other house, it means that you have the qualities of a good person.