Sumps:
Can be messy and difficult to maintain if not designed correctly.
The overflow and pipes can be loud if not designed correctly.
Possibility of emptying the tank or sump onto your floor if safeguards are not in place.
Increased water volume.
Can place equipment in sump instead of display.
Not recommended with CO2 injection as there is too much gas off.
Maintains constant water level in display as all evaporation will make itself known in the return section of the sump.
Can be DIY'd on the cheap.
Cans:
Easy maintenance.
Very slim chance of emptying the tank on the floor unless you blow a seal or assemble it incorrectly.
Usually mouse fart quiet.
Perfect for CO2 injection.
Can be stupid expensive (shop around).
So you are saying that you can't do co2 injection on a tank that has a sump? Did I understand that correctly? I have a 125 gal. With a sump that I am starting as a planted display. That's why I am asking.
Well you can..... but it would be a waste. The way the water moves would cause the co2 to gas off.
I currently run a sump on my 110 planted. All in all I prefer my canisters. This sump was a prefab and I'm just generally annoyed by it.... real reasons aside from noise, which I have brought down a good bit, I like my canister.
Because fresh water is so much less dense than salt water any given sump will be noisier with fresh water. With proper design and a bit of tweaking you can quiet it down. If you use a Herbie or BeAnAnimal overflow then the pipes can be nearly silent. But, noise is a relative thing... One man's annoyance is another man's peaceful trickling stream.
You can do CO2 with a sump. You just need to take special precautions with your setup that most people don't do. The typical sump setup that people have is inadequate for CO2.
I think personally the biggest advantage to canisters is that they are plug-and-play. No drilling, tinkering, planning, etc, just fill it up, plug it in, and forget about it until you need to clean it.