I have heard of people making BIG money doing both an ugly site and building great value and content. Try both and see what sticks
For me, it is still good if your site have good content. Visitors will visit your site again if they found out that your site is useful.