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 exibit that self control before jumping into high credit limits and multiple cards ( I have like 7 or 8 currently)