I worked with a few of those where it was horrible, because they were incompetent and unwilling to work to improve across all disciplines. But that says more about the individuals.

IMO "Knowing enough to do damage" is the worst possible situation.

A regular user who's a domain expert is 100x a better PO.