With the right projector it can be an awesome experience... Setite has his room setup with a projector for gaming and AFAIK he loves it. Need a high quality projector that supports a decent res however.
I used to play CS1.6 with a Viewsonic projector that only cost about $700 and it was awesome! I think I still have the vids of it posted around in the Off Topic forum somewhere.