If you are using DX10 / Vista, then no, that card would be worthless.
No, it wouldn't. It would do exactly the same things it would do if you had XP or any other version of Windows. It just won't do anything for games which have a DX10 version, of which there are very few, and those few that do almost all have a DX9 version anyway.