I don't think you are going to get close to 100,000 kJ
Let's take the example you started with, a 330 uF capacitor charged to 1000 V. That's pretty extreme actually unless you deal in exotic capacitors.
As mentioned, the energy stored in that example would be 165 J.
To put that into perspective, that could be generated by a load of 165 W for 1 second, or a load of 16.5 W for 10 seconds, or a load of 1.65 W for 100 seconds. Basically, any 20 W wire wound resistor is likely to shrug that off without a murmur.
What you want to avoid is the power being released too explosively before the resistor can absorb it. For the 1000 V charge, we can look at the instantaneous power dissipation which for a 50 ohm resistor was 20 kW. That seems like a bit much for a little resistor, so maybe it would be better to use a 1000 ohm resistor or so. That would bring the instantaneous power down to 1000 W and that should be OK for a fraction of a second. You basically want to avoid blowing up the wire inside the resistor before the heat can spread out. I might even go for a 5 k or 10 k resistor to be really safe.