My friend, you need to google "churning".
https://princeoftravel.com/newbie-guide/
I have 7 credit cards right now and cycle them regularly. Check /r/churningcanada for their credit card recommendation sticky thread.
To answer your question, no you wouldn't take a hit beyond the initial credit inquiry when you get the card. Just keep an eye on your rating with something like credit karma.