You are going about this backwards.

Figure out what hotels exist in the areas you want to visit. For example, Hyatt, a good place to transfer Sapphire points, has a limited footprint.

Then look at CCs that will yield points in those programs.