I second the site ThePointsGuy. It really gives great guidance on playing the points game to maximize card benefits and ensure you don’t have to pay for the majority of your vacations, etc. Obviously the self control that others have espoused is paramount, but if you have enough restraint you can always come out on top. At least here in the US anyway.Starting off with a low balance is key, especially while you are getting used to them. I would never be one to say don't put things like Vinyl purchases or emergencies on there. Just make sure it's never more than you can pay off by the time your statement balance is due. If you're paying interest, you're hurting yourself and cancelling out any perks.
My two main Credit Cards I couldnt live without are my Chase Sapphire and my Chase Freedom Unlimited cards. Sapphire is the one with the excellent reward benefits. Every purchase on Dining or travel gives you extra points and it has an excellent sign up bonus. If you cash in the points through their own travel portal they are worth more for any flights/hotels and as an added bonus you can transfer them to most airline reward programs for at a 1:1 rate (never use the points for gift cards or cash back even though its offered, it's not worth it).
I use my Chase Freedom card along with it and for any purchase that is not Dining or Travel related (i.e. monthly bills, Vinyl, streaming services, grocery shopping, etc). That card gives you 1.5x points for literally anything else and Chase allows you to transfer those points over to your Sapphire card so you can take advantage of the awesome travel redemption perks offered there.
Between using them both, like I said, I havent paid for any flights in years. That includes my honeymoon, both mine and my wifes Bachelor and Bachelorette parties, and at least 1-2 more trips a year, both international and domestic.
It take a bit of practice and savvy and if you want to research what is best for you and your spending habits, I highly recommend the sites Nerdwallet and The Points Guy. Just make sure you can exhibit that self control before jumping into high credit limits and multiple cards ( I have like 7 or 8 currently)
I used to have the Chase cards but switched over to an AmEx for everyday spending due to a ridiculous promotion they were running. It pays to keep an eye on the points guy to see the promotions at any given time.