A beautiful website makes a great impression. But if it's not useful, visitors leave without taking action. Here's what actually matters — and how to have both.