On the whole I'm not a fan. I don't mind a decent intro cutscene and a decent end game cutscene but in-between I prefer them to be fairly short and focused.
Overall, I prefer the Half Life approach though of keeping you in the game and using other approaches to conveying story/narrative.
Try to be reasonable... its easier than you think...