Something else to consider, is that some cards are "keepers." As two examples:

USAirways MC (going the way of the dodo soon) gives 10K points on renewal for the $89 annual fee.
Citi ThankYou Premier has an actual discount on plane tickets, runs about 10-12%.