I have a Super Squirt. Needed to have the motor replaced after 1 year... and had to fight to get it done. Ended up sharing the cost with the vendor. He has since moved to a new motor style.
Overall it's well made. Great idea.... and works well. Depending on the insert and the amount of pressure, the unit is subject to thumping noises as pressure is relieved. It's fairly quiet, but I wouldn't put it in a bedroom or TV area where you were expecting low noise levels.
When you buy the unit, buy an extra insert (drum) and swap them out during cleanings. It will help them last longer.