Hi,
I looked again at the photo of your 1000uF (and any others with the piggyback style) and I believe the test is flawed because you have the DUT going into the LISN and the filter board located on the otherside piggybacking. Layout/placement matters a lot. I wouldn't try to draw any significant conclusions from this setup.
OK so I modified the test setup.
This time, this is what I did (tests 10 11 12) :
Without the filter PCB (tests 13 14 15 16 17) :
Capacitors at the device connector (tests 15 16 17) :
You can see the filter under test is at the bottom left, and is inline between the device (on the right), and the LISNs (at the top).
The trace from the spectrum analyzer is from the positive-side LISN. This time I didn't bother taking the readings from the negative side LISNs as all the previous tests showed it was matching in amplitude.
Also this time I used a log scale for the frequency as allowed by the new firmware of the DSA832.
So, today I did 8 measurements with this setup (numbers start from 10 to distinguish from the previous measurements - I want each test to have a unique number within this thread):
10) Filter correctly connected
11) Filter correctly connected, common-mode choke shorted with 2 wires
12) Filter badly connected (cables to the device connected at the input of the filter, output of the filter floating)
13) No filter (filter removed and input/output wires connected together)
14) 1uF capacitor instead of the filter
15) No filter (like 13) + 1uF capacitor soldered onto the device connector
16) No filter (like 13) + 1uF//100nF capacitor soldered onto the device connector
17) No filter (like 13) + 1uF//100nF//10nF capacitor soldered onto the device connector
And here are the results :
10) Filter correctly connected
11) Filter correctly connected, common-mode choke shorted with 2 wires
12) Filter badly connected (cables to the device connected at the input of the filter, output of the filter floating)
13) No filter (filter removed and input/output wires connected together)
14) 1uF capacitor instead of the filter
15) No filter (like 13) + 1uF capacitor soldered onto the device connector
16) No filter (like 13) + 1uF//100nF capacitor soldered onto the device connector
17) No filter (like 13) + 1uF//100nF//10nF capacitor soldered onto the device connector