I do feel like most beginner/intermediate lifters with gym access would be better served just picking a standard full-body workout routine (e.g. GZCLP) and sticking to it. Figuring out which muscle groups you'd like to be targeting with specialized exercises is not something you should be doing as a novice.
> would be better served just picking a standard full-body workout routine (e.g. GZCLP) But many people aren't going to follow those routines. It's my impression that deadlifts and squats aren't good exercises for this use case because of the danger they present. Sure, they might be "completely safe" when "done correctly", but somebody using an app and trying to mimic exercises they see in videos or pictures is only…
And while progressive overload is needed, no one is going from the bar to massive weight overnight. Also, not everyone needs to have the goal of being a power lifter. Peter Attia talks about wanting his older clients to be able to a 45lb kettlebell squat, the average weight of a toddler grandkid for example.