Ok, I've got a good test sequence for dust removal tools, and, well, the Lightroom "content-aware remove" tool is, sadly, not up the the job of removing really bad dust on sensors (despite what I wrote before).
I trusted the "keep shutter closed" feature on my Sony A7IV to keep dust and stuff off the sensor, so when I changed a lens recently on location, I didn't expect a _giant_ fibre to end up on the sensor (I _did_ carefully clean the sensor before this shoot). The only positive is that it was a very good subject (difficult), for LR's content-aware remove tool to work on. Sadly, a fibre this large was too much for the tool (it's great for single images, but not for sequences).
Below is a link to a video that compares the various ways to remove unwanted fibres like this from sequences of raw images. This is a 33mpx image originally rendered to full 4K, and then I cropped it down to 720p to show just the area with the fibre. The full sequence was 700 frames, but I've cut it down to about 7 seconds at 25fps for the purposes of this comparison video. This was shot on a Laowa 15mm f/2 lens at f/22 (I forgot my step-down ring to attach my ND filters, but f/22 means the fibre is _really_ prominent; good for testing).
Comparison video:
https://vimeo.com/790763034/f4b637b3bc
1) The first segment of this video is the original footage (big fibre!)
2) Lightroom's content-aware remove tool, using default settings (I didn't choose a source). You can see, when the edges of the clouds reach the fibre, there are artefacts.
-I used it by removing the fibre on the first image, and then used Lightroom's "Sync" button to copy those edits to every other image. Lightroom showed a dialog box stating that the AI was working on all of the images.
3) Lightroom's content-aware remove tool, but this time I _did_ choose a source, just to the right of the fibre. Even _more_ artefacts!
4) Lightroom's healing tool (I chose a source to the immediate right of the fibre). Artefacts galore.
5) After Effect's content-aware tool, and this did a pretty-well perfect job. It did take about an hour to work on this 700 frame sequence, but if you want the best results, this is the way I'd go. I rendered TIFFs out of AE, and rendered those to a video file using LRT (lots of extra steps, vs. doing the fibre removal in Lightroom, but far better results).
And below are links to the full 4K versions of each of these segments, feel free to download and zoom in (of course: my copyright, so please don't re-post or send out to anyone, thanks!).
original (no edits)
https://vimeo.com/790748156/492fbf51fb
Lightroom's content-aware remove tool, using default settings
https://vimeo.com/790748063/76f2c8c515
Lightroom's content-aware remove tool, manual source
https://vimeo.com/790748095/9bf9df9501
Lightroom's healing tool
https://vimeo.com/790748116/213b3a0b53
After Effect's content-aware tool
https://vimeo.com/790748031/e059fb8d7e
Conclusion: I would not use Lightroom's content-aware remove tool on large or complex dust in timelapse sequences (sadly). I'd instead use After Effect's content-aware tool instead, despite the overhead of time required.
That said, I need to test in LR on simple dust spots against complex cloud edges, but I am reasonably confident that Lightroom's content-aware remove tool will do a good job on _small_ dust spots (but, again, I need to definitively test).