I like cutscenes in some games, but the Elder Scrolls is not such a game. In the Elder Scrolls, I'd rather the game take away control of my character and take me outside of my chosen perspective as little as possible. If Bethesda wants to do cutscene-like events in Skyrim, they should do it like Half-Life 2, which is to say, have scripted events that playout like cutscenes, but are still viewed from the game's normal perspective. In Half-Life 2, while some events would prevent you from performing all the actions you could usually do due to complications such as being trapped in something that only gives you enough room to look around, no in-game event actually took you out of the game's first person perspective.
I don't mind if it's like in Morrowind and Oblivion where there's a cutscene at the start of the game before character creation starts and one once you complete the main quest, because a cutscene at the start of the game can be a good way to get the player into the mood for a game, at least for me, and when used at the end of the main quest, it can help to give a feeling of having just seen the end of some important event that will change the fate of Tamriel, which is kind of what Elder Scrolls main quests tend to be about, whether said event is stopping a Daedric invasion or putting an end to the ambitions of a wizard impersonating the Emperor. If the main quest just ended without anything special happening, it might just feel like you completed another questline, not the central story of the game, especially with the player being able to continue after the main quest. Admitably, Morrowind also had a cutscene upon gaining Moon and Star, but one might note that all three cutscenes in the original game involve Azura speaking to the player, one of which is presumably meant to be a dream the player was having on the ship going to Seyda-Neen. I'm not sure why the Nerevarine would dream of seeing text appear in front of his eyes explaining that he was being transported to Morrowind unaware of his role to play in that nations future, but that's beside the point, the point is that these cutscenes were rare, and took place at key moments in the story, if we're going to have cutscenes in Skyrim, they should be like this too.
Remember that game "Indigo Prophecy"? That game could pull off cut scenes, go thing though, as the whole game was like a movie.
To be fair, the game pretty much was an interactive movie to begin with, so the cutscenes all fit pretty well, and that's what made it work there, in other words, cutscenes work best when they fit with the feel the game is going for.