https://learnemc.com/estimating-connection-inductance
You can even use mutual inductance of vias improve performance, either by having vias spaced close together and in the right order (https://learnemc.com/decoupling-for-boards-with-widely-space...), or arranging capacitors in alternating or doublet layouts (https://incompliancemag.com/decoupling-capacitor-design-on-p...).
As you say, just having power planes and directly connecting to them is almost always going to be superior to using a trace, despite seeing this all the time, especially in datasheet example layouts. It made sense for 2 layer boards, but not today. Just think, the inductance of the planes is practically zero, and distance to the plane from the components is going to be on the order of 0.2mm, round trip 0.4mm. Is there any way I could place the capacitor 0.4mm away from the pins to achieve an equivalent inductance? And even if you could, you can't add extra vias to lower inductance, and you don't benefit from mutual inductance.
The ELI5 for decoupling capacitors is "imagine an energy storage for quick usage"
The ELI(tired EE student) is more like the explanation above
And this concept is ok for most of the 'low speed' circuits
in RF ranges, everything is a capacitor (except when you need one), everything is an inductor (except when you need one) and the intuitive explanations break down and everything looks like dark magic
Across distances according to the power available, where ariel orientation makes a big difference, "as expected".
Putting your decoupling capacitors next to the power pins _does_ cost. Not just in board space, but I've seen and reviewed layouts where the signal traces had to snake around decoupling caps or in some cases through vias because the designer believes that putting the caps close to the pins was the most important thing...
For accurate simulation, the actual board geometry needs to be fed to a simulator that'll compute the actual impedances. Last I checked only Very Expensive Software could do that in a user-friendly way (I had to route a DDR3 bus. I ended up being very cautious so that all traces had the same topology and the same lengths, and cross my fingers. It worked).
If anyone knows of free alternatives for that, I'd be interested to hear about it.