For the past 12 years I have been using an inclosed pump similar to the Home Depot pump in the original post. Other than replacing the automatic shut-off switch about 1-1/2 years ago I have had no problems with it. It is a little noisy but at the rate it pumps out the tank it doesn't run for long. A sump pump would be quieter but I did not want to break up the concrete floor in my basement.
My darkroom gets a lot of use and, since I do Gum printing and Carbon Transfer printing, I go through a lot of water. My pump has served me well.