I'll plug my own website here since I write primarily about hotel loyalty programs. Besides my blog listed in the signature, I also have www.FrequentGuest.net where I put together pages discussing various aspects of the major hotel loyalty programs.

The main decision for someone who doesn't spend more than 25 nights a year in hotels is to decide whether you are more interested in upgrades or free nights.

Free nights preference favors following the best promotions for bonus points regardless of chain and room upgrades favors going for elite status which is most easily obtained with Hyatt, Starwood, or Hilton and can be purchased from IHG and then focusing stays with one hotel family.

My blog has dozens of analyses on the value of hotel loyalty program promotions.