First you would need a controller who's driver and firmware support
NCQ. ICHR6 comes to mind.
Second - in a home system you wouldn't notice a difference having
NCQ or not.
NCQ is only helpful where it was designed to be. On a server environment where multiple files are being accessed at the same time.
It might actually do something on a HT enabled machine and you were running something in the background that was accessing files while you were doing something else.
Basically
NCQ for a home user is all marketing hype
Of course the SATA II will be an improvement when the controllers come out