Campbell was pushed too early. Mayer was not. His problem was the bad wrist which should have had surgery circa 2022. His hitting wasn't that great but his defense was impressive. He played in just 44 games.
What the heck do you mean about offensive talent, that only three can hit? To me the big three are Bregman, Anthony, and Story, but I also like Abreu, Lowe, Duran, Gonzalez, and Ref. Rafaela had 2 excellent months, June and July- OPS's .870 and .852. Narvaez was hitting. Now Wong is.
If you want to say the Sox hitting is inconsistent, I completely agree. However, let me remind you that the Yankees have great hitting and were held to 3, 0, and 1 run in the first 3 games at Yankee stadium last week. Good pitching has also shut down the Sox a few times.