I think the funniest one was Scotty 2 Hotty! On the Smackdown brand he rarely appeared, probably being stuck on Heat or something. They then made some fuss on Raw one night when he came out to job, that he had switched brands. Two weeks later he had switched back to Smackdown.
He then promptly injured himself, waited a few weeks, and got fired!