I seem to be having no luck finding one that will do the job.
There is no single filter, at any price, that will produce sparkling clean water. But then sparkling clean water is a relative term. Some people can't see the bottom of their pond and consider that to be sparkling clean.
Multiple filters is the solution to crystal clear water. Which filters relates to very specific criteria such as figuring out your definition of clean water, climate, budget, fish load, current pond structure, etc. Far too long a subject for me. The trade offs are endless and you have to look at the complete system.
In very general terms...
Things to stay away from imo...
In all cases stay away from the combo, cheap, that target (prey on) people's desire for stuff that sounds great. You found out about the material quality of these products already, but there even when they hold together they're poor filters.
If you're serious about clear water the Skippy is just about worthless. It was state of the art like 15-20 years ago and in the past 10 years is only used in water gardens which generally don't demand clear water 24/7. Serious Koi owners moved to Trickle Tower and then Shower filters and then fluidized / moving bed.
Bead filters were also state of the art 10-15 years ago as combo filters. Currently they're only used as pre filters, but even for that I think they're falling out of favor, but still used a lot as pre filters.
State of the art imo...
Bottom drain gravity fed --> Cetus Sieve --> maybe a bead filter --> maybe a sand filter --> UV filter. That's just mechanical removal.
Bio filters used in breaking down suspended particles a fluidized / moving bed is state of the art, but Shower filters are right up there. Not far behind is Trickle Tower which has been around a long time and is still very good (10 to 30 times more efficient than Skippy or other submerged media).
Simpler...
Green is handled by UV filters, period. After that you can have a bunch of cloudy / suspended stuff. Step one is to deal with the source. The fine stuff comes from decomposing stuff. That's why something like the Cetus Sieve is useful. Removing a leaf is easy. Removing the 7 billion tiny suspended particles of a single decomposed leaf is hard and expensive. Plus there are fish health benefits.
So a bottom drain with tangential pond returns (TPR), connected to something that gets the stuff out of the water column before decomposition is a good first step. Fish poop breaks down in hours, a couple of days at the most. Again why the sieve is state of the art. Bead filters can also work if back flushed daily, but few people do that, but some can auto back flush.
Vacuuming works if you don't have a good bottom drain system.
Move plants out of the pond.
A stream can help (works the same as a Trickle Tower). Bogs can help to (works the same as a bead filter). Fabric filters (all are DIY) can work but are very tricky to get right so sometimes they work, sometimes they don't.
Trickle water changing can also product clear water even without a UV. I do think it depends on the pond however.