I've been lucky enough to visit all three. All are wonderful places. I think you have to separate Streamsong from the others, it is a very different sort of experience. Rusty and his crew do a remarkable job - the turf there is genuinely firm and bouncy - but in the final analysis it is bermuda, and links golf is played on cool season grass.
So for me the choice is Bandon or Cabot, and I have to say that it's always Cabot that I personally think of returning to. Partially it's about the golf - Rod's course really appeals to me, and when Cliffs opens in the summer I truly believe we'll see something very special indeed (and you can also play Highlands Links, which while not a links, is in my opinion one of the greatest walks in golf and one of my favourite courses). Partially it's about the destination - I loved Cape Breton with its mix of French and Scottish cultures, the great traditional music and the beauty of the area. And partly it's about the resort. Great place though Bandon is, I found it to have a slightly corporate feel, I guess a bit inevitable given the scale of the place now. Cabot, by contrast, I think because Ben and Allie play such an important role in day to day management, felt more like a family operation, more like a club almost.
Please don't think I am dissing Bandon, it is phenomenal. But Cabot is nicer for my personal tastes.
Duncan/Ally - Bandon is a long, long way to travel for a European for sure. I went because I was already on the west coast and could work in a visit without too much hassle, although delays on the flight back from North Bend to San Francisco did very nearly result in me missing my transatlantic flight home. Cabot isn't too bad though - there's a direct Air Canada flight from Heathrow to Halifax every day, and it's the shortest transatlantic crossing in existence, often below five hours coming home. True, it's a fair drive from Halifax, but imo if you go there you must do Highlands and drive the Cabot Trail, so to an extent the drive is negated. Streamsong, though, could easily get a lot of UK/Euro business. There are, after all, tons of Brits in Orlando on holiday -- and playing golf -- every winter, and it's only an hour and a half to Streamsong from the airport. You can easily do it from Orlando as a day trip.