The way I generally see these breaking down:
casual will be most common in urban and “roadside attraction” tourist paths
attentive will be most common in general wilderness paths.
surefooted will the vast majority of the time be less common than
attentive, but still occur regularly in more aggressive terrain, in areas with lower trail budgets, and/or where operators want to provide a more wild experience.
however in some areas surefooted could be more common, and not just in typical alpine environments. a lot of tropical terrain is surefooted due to being generally slick and/or covered in roots (Hawaii, a few countries in SE Asia I’ve been to) even if not traditionally mountainous.
hands for assistance is where things really begin to gatekeep people… but in areas like the US Southwest there are regions where probably 1 in 3-4 paths require hands for assistance. We saw a family of six including four small children go up a path with multiple mantles and some uneven steep bedrock in places etc. and then there’s obviously mountainous terrain.
scramble will be nearly absent in some areas, but only somewhat uncommon in others. Parts of New Zealand, the North East of the US (New Hampshire’s Presidential Range, Acadia, etc) often have well marked visible official paths that require some scrambling. Interestingly while I scramble quite a lot in the Sierra Nevada, no formally maintained trail comes to mind, and even the hands for assistance ones are almost always unmtaintained or kept at a NFS Class 1 rather undeveloped management standard.