Been searching this up quite a lot and I've finally found out how they sort of do the 'AAA' workflow in games when it's artists that actually know what they're doing. There are tutorials a dime a dozen on sculpting generally but it's amazing how flat out bad some of them are, no way of being polite about it. They're just throwing up a 10 minute tutorial on how to do something and teaching beginners extremely bad practice for the long term.
There's another method involving plane extrusion reptology after you finish a sculpt of a model and those are very common but I feel like that's for people who are absolutely anal about polygon count. This sculpt method provides a great balance for people who want to get something out results wise while still respecting the concept of clean topology.
https://www.youtube.com/watch?v=J2_uiUEcY7w
https://www.youtube.com/watch?v=TZgUAWpiIw8
Here is also a tutorial that properly goes into the workflow for baking sculpted stuff to a normal.
https://www.youtube.com/watch?v=l8xrSgyfEHs&t=171s
Could easily see myself adapting this for a general animation workflow too thought I'd post up this little research compilation for everybody to look at who might be wanting to get into 3D and of course, all of this is done in Blender. I've also been looking in more detail with texture paint and that workflow is viable as well it's just fiddly with the settings.
Like they mention in one of the tutorials and I've pointed out in the comments pages, there are tutorial makers that just skip over stuff that's really important and I think it's for the sake of getting that 10 minute click-bait video done.
Like a lot of teachers if they don't go into detail on various bits then it can potentially mean that they don't actually know what they're talking about. The good teachers I've noticed either mention they're going to make a video on it or will link a separate video on a topic they mention in more detail. Beware of the people who go 'do this' a lot and nothing else.