I've got a USP Compact in 40sw, and a USP Tactical, which is a full-sized .45 w/ threaded barrel, o-ring on barrel and match trigger.
My compact is a stainless gun (two-tone), while all Tacs are black. I could sell them both for about the same price right now, if I waited for the right buyer. Stainless USPs of all sizes and calibers are still made, but no longer imported to the US, so among the HKnistas, there is some collectable value. (Ironically, the compact was my first handgun, and I didn't know any of that at the time.) The compact was my daily carry gun for several years, until Sig released the P220 compact.
The ergonomics are good, but if you like them, you should handle the new p30 or hk45. Much, much improved. Still overpriced a bit, but like the comparable sigs, etc., they'll outshoot and outlast most of us given reasonable care.
...And there are sources for cheaper mags.
