Life is one big compromise. I have worked on some gorgeous sites where even when you type in the company name exactly, you cannot find the website short of typing in the domain name. Why is this? Because the site is completely visual, and there is little to no text anywhere stating what the site is for, and whom, much less why.
If the major search engines even know the site exists, the bots pull out what information they can, and move on, but it doesn't rank. In many cases, the search engines don't know the site exists because no one links to it and/or the web designer didn't add a Google Analytics ID and the website to Search Console to be indexed.
I love great design. But great design is not enough to get your site found by your desired clients unless you follow basic webmaster and search engine basics. Everything in moderation, from design to SEO. Do the Thing.