Just the fucking worst. A goomba is truly the dumbest, lamest, fucker you will ever meet. Completely worthless. The word can be used in a variety of ways:
Goomba maybe be used as a racial slur against the jews as well. Thank the lord because we can never have enough of those.
Look at those goombas over there, they are stealing from the temple!