I think Memoir '44 is a good choice from the standpoint that it is light, fun and fast-paced. It's fairly abstract, though, so you may not be able to visualize what's happening. You're moving around whole battalions at a time.
If you want to zoom in and get your Band of Brothers on, I highly recommend Conflict of Heroes: Awakening the Bear. It's the first of a new series of stand alone squad-level games. The action is quite fast and the rules are very elegant. It is not too much harder than Memoir '44 (though it is a little harder) and it plays about as fast. I've played it with a friend who is a veteran ASL player and he says it feels like "Squad Leader Lite".
Check it out here:
Conflict of Heroes - CoH Home Page
Be sure to look navigate to the components and examples of play to get a feel for it. The components are quite lavish for a war game.
And yet another word from our sponsors
