No One Lives Forever 2 has great graphics. On my machine (384 ram, 1.2GHz, 128Mb Gf4 Ti4600) I only get slowdowns when more than a few people are firing machine guns at once - not much of a hinderance in single player, but multi’s out of the question. I’m not sure why; I think it has something to do with the lighting.
But on yours it should run like budda. Go for it. I don’t know if it’s support your stick though.