In your first simulation you used
* ideal power supply - with zero impedance
* ideal wiring - with zero impedance
This is not realistic.
Each power supply and each wiring has frequency dependent impedance.
Each equivalent impedance can be modeled as a couple of resistors, inductivities and capacitors.
In your first simulation you used
* ideal power supply - with zero impedance
* ideal wiring - with zero impedance
This is not realistic.
Each power supply and each wiring has frequency dependent impedance.
Each equivalent impedance can be modeled as a couple of resistors, inductivities and capacitors.
A parasitic 3nH inductor with 100mR 200pF series to the supply seems more probable for an actual circuit. This models parasitics found between interconnections from 12v supply into load and the capacitor across it.
The capacitor is with 25mR 45nH of parasitics. The ripple is likely very much not accurate but much lower even than with a large series resistor between load and supply.
Whats a typical ESL range for 470uf-2200uf elecytrolytic capacitors?
You'll realize that the capacitor current with parallel connected ideal voltage source should be zero. In so far, the first setup is showing just simulator artefacts respectively the effect of intentional circuit matrix modifications that the solver is making.
It would be useful to add realistic parasitic parameters (ESR and ESL) to capacitor and voltage source.
What does your power source represent? A battery?
What does your load represent?
Your load is directly connected to the power source.
You are switching the load in and out.
I seriously think you need to give more detail on what you're doing. Whatever result you got from that simulation is based on what schematic you made on it. SPICE does not know your real system.
Higher value resistor would charge the capacitor slower than lower value once. That's just R-C transient response to the step change you create with switching the load.
I see about 20 mOhms ESR + 20 nH ESL for a 2200 uF/100V capacitor. Unless you have a low impedance battery, the power supply impedance will considerably higher.
Like Akanimo I wonder what's the real world problem behind the simulation.