I have the exact set linked in the OP. Bought it from Sears on sale around 2010. Mine has everything made in USA except for the wrenches. I consider myself a typical DIY beginner, and my cars don't really have rusty fasteners or anything.
-I rounded one bolt off with a wrench once. Haven't broken anything in the set yet.
-Yeah, it has some redundancy like the same thing in 6 pt and 12 pt. I don't really mind as it helps if you misplace a socket. I just sorted and bagged the extras so I can find them if I need to. I occasionally pull out SAE stuff for appliances. I figure the set is cheap enough that using it once or twice pays for itself vs. a mechanic, so I don't stress about paying for sockets I won't use.
-The upside of having a big set is on the rare occasion I need a deep or a shallow to fit a certain space I don't need to go out and buy a single. I've pretty much only bought an axle nut socket and offset wrenches to supplement. Not counting stuff like extensions, breaker bars, screwdrivers, etc The set also comes with stuff people generally don't care for like ignition wrenches, but I've used them a couple of times in really tight spaces and to hold shock shafts.
-I don't like that the ratcheting end of the wrenches doesn't reverse. You could run into a situation where you back a bolt off in a tight space and get stuck. The wrench heads also don't have much of an angle with the handle. I think it only goes to 18 mm for metric wrenches, and bigger sizes are probably what I'd want to add next.
Hope this helps.