There's where I just can't get into it. Different strokes for different folks.
But I like how set pieces are done in the Halo games and in Half-Life. You come across them as they happen but you're never removed from control of your character. You're free to view them or not as you choose.
I can't stand games where you're in the middle of doing something and then BAM, no control or virtually no control while you are forced to view a set piece. That's the worst of both worlds, IMO.
Not only are you removed from all control of your character but unlike a traditional CGI or even pre-rendered custscene, you also have to view in horrible realtime rendered graphics. I have to say I'm also not a huge fan of non-CGI cutscenes.
At least if I'm not going to have control over the proceedings, let me enjoy some eye candy that cannot remotely be presented with an in game scene.
Regards,
SB