Grapevine says the Rays are next (after the Red Sox) to get investigated. I would also imagine that there will be a fair bit of "who is/isn't" speculation. The penalties are just too severe to keep stiff upper lips.
Red Sox fans are disappointed and disgusted and want Cora gone (and he'll be fired once the suspension is announced, so there's no doubt about having to pay him). If it's shown that they cheated during the post-season, I also wouldn't object to vacating their title. Cora comes off terribly in this - organized it in one place, brought it to another.
Baseball is full of crap, however: the 'sign stealing scandal' is a joke compared to Bud "I know nussink!" Selig's elephant-sized lump of steroids under the MLB rug for a dozen plus years.