For me, the issue isn't Kody Clemens. He's one of the best 390 (30x13) position players in the world, and therefore belongs on an MLB roster somewhere.
The issue is what his usage rate says about the rest of the roster.
He's a low AVG hitter with spurts of good-to-very-good OPS. He can play several defensive positions ranging in quality from passable to pretty good. On a good team, that's a utility player. On a really good team, he might even be expendable. But with this bunch, he's been one of the better hitters. The fact that that doesn't bode well for the team as a whole isn't his fault; he's maximizing his abilities. But that doesn't change the fact that this team won't be meaningfully competitive until he's closer to the bottom of the performance ledger.
They're different players, but it's the same general concept with Arraez. He's been pretty much the best version of himself this season, might even be an All-Star. But the fact that he's been their best hitter is a big reason why the Giants have been terrible. On a good team, he's a complementary piece setting up the truly valuable hitters. But you can't be a good team when someone like Arraez is your best hitter, just like you're not a good team if Clemens is getting starter-level PAs. It's not a knock on them directly, but their usage is a bellwether for the quality of your roster.