FWIW, several time-tested programs meet only a handful of those criteria, like Starting Strength, most 5x5 plans, 20-rep squats, Bulgarian weightlifting, Sheiko.
1) Progressive overload via volume and/or load on a consistent basis - either workout to workout or weekly or biweekly.
2) Training frequency, volume, load, and exercise selection are coordinated towards a specific pre-determined goal while maintaining an underlying focus on joint health without distracting from working towards that goal (this can be accomplished with specific, separate mobility work and/or deliberate attention to exercise choice and volume).
That's pretty much it. Broad guidelines because the concept of a "great program" isn't universal, it's actually the opposite. A great program is very specific and context-dependent, so very-big picture principles are the only "musts" that every program should share.