It does depend somewhat on the energy level of the noise, source impedance and its main frequency components, high energy levels require more capacitance, a low source impedance of the noise also requires more capacitance, smaller caps tend to have lower ESL and fairly low-ish ESR so they filter HF noise better because they present more pure capaciatnce at the frequencies of interest, larger caps may be very high impedance and inductive at frequencies above those intended by the makers.
Regards, Orson Cart.