My website looks hideous, and I figured that I need professional design help after all. Where should I look for branding consultants and UI/UX designers?

It happens quite often, yes, people that are good with coding realizing that they need professional design help after all. It happened to me. And I can recommend a good company that does services like this now to you. Here, this article will help you discover the best branding identity agency https://clay.global/blog/top-branding-agencies . All the companies listed there do web design as well. So check it out!