Yes, many of us do this. My wife and I have made about $5,000 this year from credit cards, plus a couple hundred thousand miles.
Just realize that Capital One will pull your credit from all three bureaus. It probably doesn't matter to you if you are just starting out, but as you open more it can be a pain.
If the spend for that card isn't a problem, you could grab Chase Sapphire Preferred, the Capital One card, and the Bank of America Premium card. Those will each get you $500+ after hitting the minimum spend.