Crystal load capacitance for low power applications
What are the actual numbers like in terms of power dissipation?

Below are a series of diagrams I produced when investigating crystal oscillator power dissipation changes versus external drive resistance (R1) and loading capacitor (CL1 and CL2) changes. The equivalent circuit is a good place to start before jumping into the actual power dissipation: -

Changing values for R1 (250 Ω to 1500 Ω) with CL1 and CL2 fixed at 20 pF produces slightly different oscillation frequencies (phase shift = 180°): -

Images from here.
The crystal is modeled as shown in the top picture. The crystal equivalent circuit has been chosen to produce a theoretical series resonance at precisely 10.000000 MHz. That frequency is determined by the components inside the orange box. The image link gives more details if you need them.
The important thing to note from above is that the oscillation frequency is somewhat &quot;R1&quot; dependent. The oscillation frequency is produced when the phase shift = 180° i.e. adding a &quot;perfect&quot; inverter generates an overall phase shift of 360°. Further down I show how an imperfect inverter can increase power dissipation in the crystal.
Looking at the graph above, the stablest oscillation frequency is the one where the phase shift passes through the 180° point with the least ambiguity. This tells us that a higher drive resistance (R1) produces better crystal stability. A higher drive resistance also produces the least amount of power dissipation in the crystal. However, things look a little different when we vary loading capacitance. The next picture keeps R1 at 500 Ω and varies the loading capacitors: -

The conclusion here is that higher values of loading capacitance produces a more stable frequency (less ambiguity in the frequency that yields 180°) but, the power can be significantly higher compared to using small values of loading capacitor.
But the inverter gate used also can play a big role. If the inverter has stated propagation delays of (say) 10 ns, the required phase shift to be produced by the crystal is somewhat less that 180° i.e. it might be closer to 160°. The effect on power dissipation is shown below: -

The linked article explains that a data sheet propagation delay of 10 ns would strictly erode the required crystal phase shift by 36° but, because the gate is used in its linear region the overall delay might be about 50% of 10 ns leading to the crystal being required to produce a phase shift of about 160°.
Hope this helps. The subject is as deep as you want it to be. More loading capacitance equals better oscillation stability but it also equals higher power dissipation in the crystal that can also lead to oscillator frequency degradation.