Actually, if you have a regular turntable and receiver with a phono input, you don't have to bother with USB at all. All you need is a Y-Cord that goes from 2 RCA male plugs to one female miniplug. Then get a male stereo-mini to male stereo-mini patch cord (6 feet should be more than enough unless your computer is a L-O-N-G way from the receiver). Plug one end of the cord into that Y-cord and the other to the "line in" on your sound card. The Y-cord's two male RCA plugs go into the tape out (i.e. record, not play) on your receiver.
After that, it's up to your software (personally, I use CFB Software's "LP Recorder" -- download from cfbsoftware.com -- but there are others). That way you can use a good turntable. Yes, I agree that most USB turntables are one small step above junk.
You can get all the cords at your neighborhood Radio Shack or similar electronics store. They're pretty cheap and won't cost near as much as a USB turntable -- even if you include LP Recorder software.