I have not been to Streamsong, but have played the other 3.
All are terrific.
For an American, Cabot golf is outstanding, amazing, unique--and the trappings outside the course are great also. Lobster every night, pretty village that is very different than the US. The only difficulty is getting there. If you can get a private plane, that's great. But if not, it's still worth the trip.
Bandon, it's hard to say, is the older brother. Great golf, great amenities. Still hard to get to. Longer season. If you haven't been, make it happen.
Sand Valley shouldn't be missed. Only played the original course but walked Mammoth. The site is much easier to get to, the one course was great/surprising, and the experience was terrific.
I hesitate to rank the 3 experiences. All offer something different, yet all are equally worth the trip. The golf at all 3 is worth the cost and the difficulty of access. The seasons for each are somewhat different. Go to the one you haven't been to yet.