I don't think there's enough time for most builders to build many amazing things and use them all in-game. It's too much work. The most prolific/famous builders seem to be putting something out multiple times a week (almost everyday) because the YouTube algorithm is unforgiving, so at most they'll probably only do minimal play testing.
I think you have to search for smaller creators with fewer builds if you want them to work flawlessly. They will be harder to find because neither YT nor the gallery rewards that. But it really shouldn't take much to fix mistakes or get a build optimized for your machine.
ETA: My computer also has a high tolerance for nonsense in builds so clutter and narrow paths don't bother me. A lot of the builders could be on machines like mine where we can push the limits of the game and generally be fine. The AI processes fast enough to where the Sims can navigate intricate pathing okay.
