I personally would eliminate sand valley from that kind of trip. There are basically only two courses which seemed relatively similar to me. Especially if you are doing 36 per day plus sandbox at the end. They claim two restaurants, but they share the same menu. They are fine for one or two days but after 4 or 5 days would be repetitive. There isn’t much in the community. At least at bandon you can go into town and get different foods. Ymmv.
I think bandon is far ahead of the others in America you mention. I guess streamsong might be on the list. I’m not sure pinehurst meets your walking only definition. You can of course walk most of the courses yourself even if others ride, like pinehurst. I guess if you include pinehurst, you could include pebble area. If you include St. Andrews, can you include many in Scotland and Ireland?
Maybe if you reviewed your experiences from the trips we could provide better commentary?