Aquaponics sounds good in theory but its hard to pull off. You can still keep fish if you want but juggling that with getting the nutrient balance right for plants is tough.

I saw a yt video of a guy that was heavily invested in aquaponics for several years say he's then switched to adding urine into the water. No need for hydroponic fertilizers but also no need to complicate things with fish. He would also add more stuff into it like composted stuff to get a wider range of nutrients besides ammonia -> nitrogen.