I'm building a website to pull strava activities into my google/apple calendar (without needing permissions or logins)

https://stravatocalendar.com/

It's working well and I think I can use the same "backend" to pull this data into a spreadsheet which could be useful for data hungry users/coaches/club and event organizers/etc.

Data hungry users/coaches probably already use something like TrainingPeaks[1], which has the more advanced features that you seem to want out of Strava. Might be worthwhile to check out if you're looking for ideas.

[1] https://www.trainingpeaks.com/