I have 3. Two in 40 and a mk 23. I also grew up with rainbow six and splinter cell. There are no guns built better nor more reliable. There are however, many many guns built just as reliable and as well, With better ergonomics and far better triggers and for less money. Everyone who shoots with me for the first time wants to shoot the USP. Next to none actually like them. They just dont feel as good as most guns today (nor as good as most guns available back then, Glock, beretta, sig.... imo) . I'd take a 22x sig, beretta 9x, or most any striker gun made over a USP personally if I were limited on choices.
At this point in time, with the available options we have, at the prices we have I cant imagine recommending a USP to anyone unless its nostalgia or they have other guns and just want a USP, in which case it's a fine firearm. I do think that they are one of the few combat handguns that will increase greatly in value though.
My point is that the USP is definately one you should shoot before buying. I like the gun, and its reputation much better than I like the company or actually shooting mine. Even the gamer kids 20 years younger than me that want to shoot them tend to lose interest after they shoot a 226, 220, 320, Beretta, or even a glock.
All that said, if they released a 10mm mk 23 just for kicks I'd be on the list to get one.