Can you filter out power supply noise by using a capacitor with a resonant frequency that matches the noise frequency?
In the particular example you have in front of you, if ...

a) the power supply has narrowband 61MHz noise and
b) your capacitor has an SRF of 61MHz 

then yes, that capacitor in shunt would provide a good reduction in the noise voltage, and probably the best you'd get for a single cheap component

However, the SRF of capacitors, and with that the notch frequency, is not well controlled. As it depends on a residual parameter, the inductance, it may change. As that parameter is Bad, manufacturers are trying to improve it all the time, and may just improve it between batches. Different manufacturers may achieve a different inductance in parts that look the same. This means that SRF is neither consistent across different sources, or even reliable for one source.

Using a notch filter to improve a power supply only works if there's a single frequency of noise, and that's consistent between all examples. If it's broadband, or moves with time, or between supplies, then a fixed frequency notch is no good.

A single shunt component will have only a certain depth of attenuation. If you need more, you will need to build a larger filter anyway.

The thing to do is to design and build a lowpass filter from several components. Choose them with SRFs well above the highest frequency of interest, so that if (when) those SRFs change, they do not affect the performance of the filter significantly. Design the filter to have a stop band covering all of the potential problem frequencies, with a stopband deep enough keep it clean at the load.