To me, an advisor is worth it if you have a decent amount of cash/retirement/etc and looking for what to do. The benefits of what to do from a tax perspective, what types of accounts to have, etc can all be worth it with the right advisor.
That said, let's talk personal investing. There are general rules to follow:
Maxout company sponsored retirement
Keep fees as low as possible
Avoid leverage and individual stocks
Stay in the game and compound as much as you can
How many years to retirement are you?
How risk adverse are you and will you stay invested during the bad times?
How much reserve cash do you need for emergencies?
Tons of questions to answer for yourself, but the important thing is (especially if you are younger) to not worry about timing the market and spend hours looking up individual stocks, the math is 100% there to support buying low cost index funds like VOO (as mentioned above) and not touching it until you get closer to retirement.
In terms of resources, I REALLY recommend checking out The Compound and Friends podcast, which is hosted by Ritholtz Wealth Mgmt, and they have some great podcasts specifically for individuals such as Portfolio Rescue. I listen to 4 of their podcasts probably weekly, I'm actively trading and investing though so I like to keep up with it all.
https://www.youtube.com/@TheCompoundNews
TCAF - weekly podcast with someone in the industry to talk through what's happening in the market, background of that person, insights, etc. Sometimes it's traders, sometimes its journalists, sometimes its analysts, this is what got me to these guys.
Animal Spirits - 1-2 a week about what's happening in the market, hot topics, etc
Ask the Compound - Portfolio rescue podcast, they take questions from listeners (prior to podcast) and talk through their answers from a financial advisor position, and they'll bring in experts from their company to talk about tax, insurance, FA, etc. Maybe the best place for you to start.