I think it's mostly a matter of preference. If you have a species that prefers high flow (like those from a fast moving river) I think it's beneficial. If you have sand, it's definitely beneficial since they blow all the junk to one spot and give it a much cleaner look. Out of my 6 FW tanks, only 1 has a powerhead, and that is because it has a sand bottom and filter feeding shrimp who really need high flow to feed properly.