The greatest drama series from 2003-2008, "The Manny Rumors" aired on NESN.
The premise was like this: first he wants to be traded, then he loves Boston and wants to stay, then he hates Boston, but then he loves it again, only to complain about his knee, and then hate Boston some more, and eventually he got traded, and "The Manny Rumors" was canceled.
In all seriousness, there was quite a bit of drama in the Red Sox clubhouse since the four-team deal that would've sent Manny to Texas for Alex Rodriguez and Nomar Garciaparra to the White Sox for Magglio Ordonez. The trade fell apart when A-Rod was sent to the New York Yankees.
Fast forward to 2005. A trade going right down to the deadline.
July 31, 2005. Jon Papelbon's major league debut overshadowed by a trade that didn't happen.
A three-team deal would've sent Man-Ram to the Mets, Anibal Sanchez to the Devil Rays, and Aubrey Huff to Boston. Tampa nixed the deal because of the Sox refusal to include Jon Lester, a move that would later pay dividends for the Red Sox.
This deal was better off not going down, as Anibal Sanchez would be added in the trade the brought Josh Beckett and Mike Lowell to the Red Sox.
Other deals that fell apart were; Manny to Baltimore for Miguel Tejada; Manny to the Orioles again, but this time the Sox would've included Matt Clement for Tejada and a little-known outfielder named Nick Markakis. This deal would've immensely good for Boston, while not so good for Baltimore.
There was one more deal I heard, right before the trade to LA: A straight up deal that would've sent Manny to the Dodgers for Matt Kemp and Andre Ethier, but the Dodgers wanted more in return.