Accessing Amazon Global Infrastructure region table (for RestAPI or dotNet)

AWS Systems Manager can help with this. It has SDKs for various languages as well as a rest API.

For example, to get all the regions for the AWS Athena You can use GetParametersByPath with the path /aws/service/global-infrastructure/services/athena/regions