Hollywood is by definition all about fantasy but I must admit they have raised the realism bar somewhat in recent years. Not that they could have lowered it any.
Some of my more recent favorites:
We Were Soldiers
Blackhawk Down
When Trumpets Fade
Band of Brothers (the upcoming sequel promises to be as good as the original)
Generation Kill