I'm still a bit confused, to be honest. I may have missed something fundamental in the possible scenario where current on the neutral from outside could cause the 100mA RCD to trip (assuming the 30A is faulty) with a 500Ω leak.
Forget about that for a moment. Although it's the underlying issue, the question you asked is more basic, and rather different (i.e. nothing to do with any 'current from outside' {of the installation} ).
Surely a fault between neutral and earth of 500Ω would cause it to trip during normal usage. 230V/500Ω = 460mA.
Mr Ohm would be proud of you - but
only if the potential difference between your neutral and earth were 230V - which I don't imagine is what you expect to see, is it?
I don't know about yours, but even with quite high loads operating, my neutral is rarely more than a volt or two above my installation's 'earth' potential (at origin of installation) - let's say 5V to be generous (indeed, if you have TN-C-S it's hopefully zero at the origin!). Per Mr Ohm again, a 500Ω N-E fault would therefore then result in a current of 10mA following through that fault, hence only a 10 mA imbalance in the RCD - not enough to trip it.
Even if you moved a long way from the origin, to the end of a final circuit loaded so as to produce the maximum permissible VD (5.75V in neutral), you still should only have that 5.75V N-E pd with TN-C-S, potentially a bit more with other earthing systems.
Is this not comparable with a person with 1,000Ω body resistance touching the neutral? Would not the RCD trip?
Just touching the neutral (and earth)? Definitely not, unless there was something very wrong with your installation. Per above, if one assumes a 5V N-E pd, only 5mA would pass through you to earth, far too little to trip a 30mA RCD. To get 30mA through you would obviously require an N-E pd of 30V - which is most unlikely to exist under normal circumstances.
... does the above make sense?
Kind Regards, John