It is still free. And still awesome.
I can't really say for other consoles, but the orange box is an excellent value for what you get. I've put many many hours into it, and I am still playing.
Team Fortress 2 on xbox live alone is worth the price.
EDIT: Anyone know when Half Life 2: episode 3 is supposed to come out?