Travel rewards credit cards promise free flights, hotel stays, and exclusive perks. But is the reality really that simple?