Is there anywhere one could see an example of these tools being used together in and end-to-end workflow to get a quick sense of what VFX tools are capable of these days? It's a total black box to me, and I have no interest in it beyond the sheer curiosity of how far the tools have advanced and how much one can do with those with enough experience and effort.
If you're after what the software is capable of, then looking at the films to some degree is obviously the Litmus test :), but more usefully VFX breakdown videos might be useful or demos of the software described.
I can give you some links to breakdowns the studio I work for worked on, but unless you know the software to some degree, it's probably a bit too fast to really understand exactly what the software is doing, and doesn't really show the software being interactive with or used, but:
Yeah, if you're looking for workflow tutorials with specific tools, it'll be a bit more difficult since a lot of really big shops will roll some of their own tools between big commercial offerings like Lightworks, Resolve, Blackmagic Fusion, and the handful of very prominent open-source tools like Natron and Blender. Every project is going to be both chaotic on some level, and kind of protective of specifics.
Pixar in the past has been pretty open about their workflows, but those workflows are also full of their own tooling and technologies, a lot of which they've open-sourced: https://github.com/PixarAnimationStudios (cf. this 2020 interview with Nick Porcino, which calls out some things about open source: https://www.aswf.io/bts/nick-porcino-pixar/ )
Oh hey, speak of the devil, ASWF just put out a report a couple weeks ago about open source in entertainment: http://report.aswf.io/ (PDF)
You can check http://vfxplatform.com/, which is a high-level attempt to provide at least guidelines for a reference platform, and this SIGGRAPH 2021 presentation by Nick Cannon (Disney) and Francois Chardavoine (Lucasfilm/ILM) on it: https://www.youtube.com/watch?v=i4tXrtJBqK0
