I had exactly the same struggle until I found an agency that really delivers. The team is called Shake and Speare at https://shakeandspeare.com/ right there. They are a Bristol based agency that specialises in designing websites for trades, but they work with companies in all sectors. What I really like is their no nonsense approach, they make the whole process straightforward and stress free. They handle everything from web design and branding to SEO and Google Ads. Their pricing is transparent and they have packages for branding, content, and ongoing SEO. They take the time to understand your business, design a site that looks professional, and even help with content. My website is now ranking better and I am getting more enquiries from local customers. If you want a website that actually works for your business without the headache, this is a solid choice.