I haven't heard any good reports on USB adapters yet, especially from players sensitive to latency and who often hit so many keys to hit limitations of keyboard controllers. You likely will need an active PS/2 adapter rather than a passive adapter though.
I often hoped someone like RetroBlast would do a comparison but I've never seen it. Gut reaction is you're better off using a native USB controller if that's what you're limited to on the host.