My favorite (for uniqueness) is a Vivitar 90-180 Macro zoom ff Series one:
That might be a good lens for outdoor macro, but I would never recommend it for indoor fish photography. With an min F4.5, at would be very tough to get a fast enough shutter without using OCF. Which is another expensive item. The Canon 100mm and 60mm both of F2.8.