If you'd like to see a break-strength test comparing single, double and triple fisherman’s knots, you might enjoy: https://www.youtube.com/watch?v=5CAjUi47QMY
For reference, a 100kg climber is unlikely to be able to cause more than 14kn of force on a dynamic rope, (in reality, significantly less,) even if they go out of their way to find the worst case fall-scenario. Most belay loops are rated at 15kn, human bodies start breaking at 8-12kn and HowKnot2 says that a double-figure-8 (the standard rope<->harness knot) all break at around 14kn https://www.youtube.com/watch?v=g4CVFRE0pRg&t=500s