I have my CapitalOne No Hassle Miles Card. I earn airline miles as I use it. It's good because they never expire and you can exchange them for cash or merchandise if you decide you don't want miles. I used my card for 2 years...put about $1k-2k on it per month and got $600 back. I like it a lot...the only problem is they are very conservative so my credit limit is half what it is on my other cards.
I also have a CitiMaster Card. It's another rewards card. I get cash back on all purchases and I got $100 just for signing up for it. I don't earn quite as much as my CapitalOne but it's a good backup because it has a much higher credit limit.
Also, you may not even have to get a new CC if you don't want. If you already have a Visa your card may be eligible for Visa Rewards. Just go to their website and try to sign your card up. It will turn your visa into a Rewards card.