Well, I think overall the 5D MKII is a good upgrade (considering the price point). I do question Canon's decision to put video in the camera. I would rather they put their R&D and money towards an improved AF system (say a 20-25 AF system), built in wireless flash control (like Nikon cameras) without the need for an ST-E2.
While people were initially excited about the video, now that the camera is actually out and people have got a chance to play with it, I think the excitment has died down. There was great dissappointment to know that you cannot control aperture in video mode, so people now have to "trick" the camera to get the aperture they desire. I wish they would have saved the video for the XXXD camera's, which would appear to be closer to the target market for video in SLR (the market being people who upgraded from their P&S to their first SLR, and were used to doing video in the P&S). Evidentally Nikon thought that this was where the market was at, because they opted to put video in their D90 (more consumer focused), than in their D3, D300, D700 which are more pro-focused.
Again, while I don't fully agree with all of the features Canon put into the 5D MKII I still think it's a good buy for it's price point.