You have there, in a nutshell, the difference between the outlook of good and bad designers.
Bad designers care about whether they like the design.
Good designers care about whether the end-user likes the design.
Idealistic designers care about whether the end-users (meaning the people who will, say, visit the website) like the design.
Pragmatic designers care about whether the client likes the design.
It's quite a bit harder to make money as an idealistic designer, unless you can wield conversion rate data at the client. If you're just one designer on a team working for an agency, who's been given a "brand policy" document by the client? No chance.
[Top tip - never ask the client "What do you think of X?" instead ask "What would your customers think of X?". You'll be amazed at the different kind of responses you get.]
Should a site look good? Absolutely. It never hurts anything to look better. Can a site look ugly? Absolutely. If your business is strong enough, there's no amount of bad design that can hurt it.
The main thing though, is that more attractive designs don't necessarily convert better. People think they do, because you're turned off by ugly designs, and for sure, if you've got two sites up that share the same interface, and one is prettier than the other, the prettier one will likely win your business. But if you take those same sites, and have better copy on the ugly site, it may well convert better. If your pretty design is hard to use, it may well lose.
So yeah, if your web designer cares more about the end user or themselves than whether the design is effective, then you're paying for the wrong thing.
But I'm nitpicking. From what I've seen, in 99% of cases looking more pro helps.
I disagree that designers place too much importance on what they do. Design is very important. The mistake designers make is not knowing when it's important. They just want to design everything whether it's necessary or not. I was going to put an analogy here but I lost my train of thought.
Nope. Awful design survives when the users incentives for using the site outweigh the pain caused by the bad design.
I was comparison shopping for marbles this afternoon (don't ask) - several sites just got closed because I couldn't trivially see what the P&P was.
I'm traveling to the US this year. Which means I have to get ESTA authentication from the lovely DHS. It doesn't matter how fking awful that site is. I will go through the process until it works since I have no other option.
That's not awful design.
A lot of businesses can get away with terrible websites for the same reason I can get away with terrible business cards: 99.8% of the business is elsewhere. If you're Nobu your website could be done by a 4th grader in Flash and you'd still sell sushi at $100 a plate.
That's the part of the answer you won't mind hearing. The other part is designers vastly overestimate the importance of design and that what designers like about designs is in many cases orthogonal to their effectiveness in convincing customers to enter business relationships. (I'd say a variant of that regarding programmers, too.)