Can Book Cover Designers Really Boost Sales?

I’m curious about hiring book cover designers for my next book. Do professional designers really make a difference in attracting readers and increasing sales, or is it mostly about the content? Are there certain designers who consistently deliver results, or is it hit or miss? For indie authors, is it worth spending money on a designer, or can DIY tools create covers that perform just as well? I’d love to hear your experiences.