There are many different characters in MacBeth trying to accomplish different things for themselves. However, in my opinion, the only characters who really profited from and got what they wanted out of the whole situation were the witches. They are the ones who basically caused the majority of the problems in MacBeth and I think that they knew what was going to happen the entire time. Even though it may look as though they gained nothing from everyone else's misfortune they actually succeeded in making MacBeth do evil deeds and winning him over to their side.
MacBeth may have gotten what he was after in the beginning when he was crowned king, but afterwards of course he lost everything he had. First, he lost his wife, then he lost his friends, and finally he lost his life. The witches are the ones who put the idea into his head about being king, and actually caused him and his wife to kill the king. This is what started everything bad that he did. Even having his best friend, Banquo, killed.
MacBeth's wife had a similar situation. Things went well for her in the beginning but soon changed. After MacBeth told her the prophecies and she convinced him to kill the king she became queen, and MacBeth became king just as she wanted. But soon things changed and she slowly went insane trying to protect MacBeth and herself at the same time, until she finally died.
The king, obviously, did not prophet too entirely much