I'm of the opinion that at least in the case of more complicated financial situations (like if you have some combination of factors such as owning a business/businesses or multiple rental properties, having many different income streams, weird inheritance situations, needing to plan long-term for a child or other relative mentally incapable of looking after their own financial affairs, etc.) it can be well worth speaking to a financial professional, at least as a one-time or occasional check-in where you pay for the consultation and not for ongoing services.
However, I'd have a lot of questions before I'd pay for someone else's advice. I'd want someone credentialed, like a CFP or CPA. They should adhere to a fiduciary standard. And I'd want to be crystal-clear on how they charge for their services, and look for someone who is fee-only rather than fee-based or commission-based. And have experience with whatever specific issues I wanted to discuss with them.