The Amazon charge account you mentioned, is that their credit card?
Although your credit limits are on the low side, you have several accounts and a good credit score, if that is your FICO and not a bureau score. But if Best Buy denied you for their MasterCard then the chances of qualifying for a good rewards card may be difficult for now.
Also does it hurt your report if you apply for a card, get it, then decide to cancel the card?
It won't hurt per say, but each hard credit check shows on your report for 2 years, affecting it for 1 year. Canceling the card right away might bring down the average age of your accounts. If it doesn't cost anything then I would leave it open.
Disclosure: I am a moderator/paid staff of this site, which does have advertising relationships with some credit cards that are discussed and linked to. Regardless, anything I say is my honest opinion.
Current Cards: American Express:
Blue Cash, Simply Cash Bank of America:
WorldPoints Platinum Plus Chase:
Amazon, British Airways, Cash Plus Rewards, Freedom, Ink Cash Citi:
Thank You Premier, Dividend Platinum Select Discover:
MorePrimary Everyday Card: American Express Blue CashPrimary Travel Card: Chase Sapphire Preferred