As someone who just recently switched careers to be a financial advisor, I find your experience to be disheartening. I spent twenty years as an engineer but didn't feel fulfilled because I couldn't see a direct impact of my labor improving the lives of the people around me, so I wanted a way to more directly benefit those around me. I agree with the general sentiment in this thread that it's hard for the average investor to quantify the financial benefit of working with an advisor on an account with fee-based billing.
Vanguard (and others) have done research on this (https://advisors.vanguard.com/VGApp/iip/site/advisorsec/researchcommentary/article/IWE_ResPuttingAValueOnValue) and have quantified the value of an advisor at somewhere between 1.5 and 3.0% on average (and this is Vanguard saying this). Many people are somewhat short-sighted by the decade long bull market in US equities where it's been hard for any active strategy to outperform, but a lot of value from working with a professional comes from behavioral coaching during long bear markets, as well as tax strategies closer to retirement.
I sympathize with not wanting to pay someone else for something I feel capable of doing on my own. I hate paying an electrician when I can do basic electrical work, despise hiring a painter or dry-wall installer to little repairs here and there, and don't even get me started on paying for insurance. The true value you get from any professional isn't the daily value they add to your life, it's the way they swoop in to save you during an emergency. The story I like to tell is about (of all things) my insurance agent (and I'm not here to ding or promote anyone specifically so I'll leave names out), but you could show me all the commercials in the world about how I could save 15% by switching to some online insurance company with no local office, and nothing you could say would motivate me to switch. I have a personal relationship with my agent, and I can say with 100% certainty that if I were on my lawn watching my house burn down at 2 AM, my agent would be there as fast as he could to put his arm around my family and me to say "I know this looks bad, but I'm going to take care of it, let's get you to a hotel and don't worry about a thing." That's where professionals are worth every dime, but you have to work with someone who genuinely cares about you and not their take home pay.
So if you want to go it alone, you certainly can (I send many people that direction if it's best for them), but if you find a good professional and give them a chance, there are many ways they can add value to what you're doing. Financial Advisors (and CFP's in particular) are there to help with all aspects of your financial life, including tax planning, estate planning, risk management, education funding, charitable giving, etc.