I find they can make some things look objectively "good", but they just look generic and it feels very easy to spot a site that was made without the vision, polish and judgement.

You can get LLMs to create some truly unique sites, but it takes a lot more work than a few prompts.