The nearest equivalent is Pirlo or Xavi in their declining years, and no sane manager would play either in a midfield two for the reasons you pointed out. They were crucial players for their teams and so could yaya given the right tactics.Having Yaya in the team makes it absolutely impossible to press as a team, he's not physically or mentally capable. Hence why we get systematically beaten by every half decent team who is prepared to have a go at us. We're simply to easy to play against with him in a two.
The options are either drop the pressing style, which then means your opponents are allowed to dominate possession if they want or play Yaya in a three, which then means you have to drop Silva or play him out of position wide left. Both stupid ideas fundamentally.
A sensible option would be to play Yaya +1 against weaker, non-pressing teams like Villa or when chasing games, and play Yaya + 2 (two out of Fernando, fernandinho, Delph, garcia) against top notch teams
That would require a degree of tactical flexibility and pragmatism, analysis of opponents, and willingness to play youth or non-star players when the situation demands, rather than just sticking in the 11 most expensive players you have on the field.