Marriott might be an option.

They're offering free upgrade to gold right now which will give you good rooms, extra points, and free brekkie. See:

http://www.flyertalk.com/forum/showthread.php?t=831454

Platinum or Centurion AMEX
 

Do you by any chance have a platinum or centurion amex. If so you are automatically upgraded to a gold member through SPG. This will allow you to earn extra points as well as possibly recieve a comp upgrade.

this link will take you to the enrollment page. call up amex and they will take care of it over the phone.

https://www143.americanexpress.com/c...ARDS/137/1/0/8

My take:
If you plan to accumulate most of your points through hotel stays, then you have a number of good options - as noted in the insideflyer article mentioned earlier in this thread; they especially liked hhonors, choice, and wyndhem (I agree re hhonors)

But if you will be getting your hotel points through credit card spending, SPG is the best choice. With their CC You get 1 point for $1. hhonors gives you between 3-5, MR 1 (with their premier visa you can earn 2 on airline, dining, car rental), priority gives you 1 per $1.
But 1 starpoint = about 5 points in the other programs (a rough estimation, but still fairly accurate)

For example: to use Marriot own comparison (meant to show the benefit of their program:
http://www.marriott.com/marriott.mi?page=beherefaster

Here You would need $130,000 in CC spending to reach that reward with MR ($280 grand with PC), $72,000 with SPG.