1. is very doable. My local gym uses an app to manage monthly leaderboard already and people seem to like it. There is a friendly rivalry in my local gym where people "fight" for the top spots
2. A lot can be done from the helping beginner angle. A coach told me he wishes to show hip placement and movement to young climbers, as it is easier to show than to tell an 8yo. I thought of doing inverse kinematics from holds to resolve body positions, so I get beta (sequence of moves) for each problem right away. Too hard, don't know if it is solvable.
A bit tangential, I think in theory the climbing wall with a set of problems is itself an identifiable code. We might get rid of the QR code too. I can create an index of visual features that resolves to a camera position, raycast from camera position to narrow down to maybe 3-5 problems, and select videos from there. But I digress.