Not sure if this is strictly hydroponics but my fishtank loves the plants and the plants love the tank.
I have quite a lot of filtration but the plants absorb the nitrate that I otherwise would have to do more waterchanges to remove.
In the tank I have fancy goldfish who really do produce a lot of ammonia
Also a short video
A lot of aquaponics people seem to dislike having plants right in the tank, but i always liked the look of it.
It must be because the fish will eat the roots if they are big enough