The filters usually aren't powerful enough, and you want a bottom drain. Those ones that come with submersible pumps are no good. Get a good pump, but make sure you have a priming pot on it so debris doesn't get caught in the pump. This is the pump that I have: https://www.advantageman.com/product_p/es3500.htm
You want to lower your bioload so as large a pond as possible with as small a fish load as you can limit yourself to to best reduce pump/filtration costs. Think about what you will do when the goldfish reproduce or get too big for your setup. It's much like figuring out what you are going to do with unwanted cockerels/roosters.
Remember that is just the filter. You still need to factor in pump costs to drive that filter (typically $250+)
Thanks for all the help! That seems like a really big pump but maybe necessary for waterfalls?
I was considering these two kits and it seems like it has a pretty powerful filter and pump for the size of the pond? Especially the first one which it says is for heavier flow and waterfalls and stuff. Under "tech specs" it lists exactly what is included and all of the pump and filter sizes, gallons of the pond, etc.
https://www.thepondguy.com/product/the-pond-guy-rapidflo-ecosystem-pond-kits/pond-kits
https://www.thepondguy.com/product/the-pond-guy-allclear-ecosystem-pond-kits/pond-kits