I hate to sound like a young kid/snot (I'm only 33 which is probably on the lower end of forum average), but computers have had all these issues for years. The issues you speak of in your original post are the same issues that folks like my parents have that for whatever reason they just can't navigate the computer market like they can other ones.
I haven't had a store bought computer since 2000 when I bought a 900Mhz Athlon in a crappy HP box when I went to college. I got rid of it in 2002 and built my own. Even when I worked IT for the local school system in 1998, it was well known that pretty much any off the shelf system you are going to buy, is going to come with more crapware and shovelware and ads for AOL than it was anything useful.
And maybe its just my personal bias, but of the "off the shelf brands" Sony has long had a history of being way overpriced stuff. And second only to Apple (and maybe not even second) in trying to use proprietary software and hardware connections to keep you in their particular ecosystem.
Most consumer electronics can be safely used *without* installing all the bloatware software that come with. Whether its a camera or printer or whatever, you can hook the thing up to a USB connection and get photos off the thing without putting 500MB worth of Sony adware on your machine. Just another note, anything that installs, in one of the 3 or 4 screens that ask you where you want to put it and stuff, will almost always have a checkbox that says "please install a Yahoo search bar and make some other browser than the one I have my default stuff", and most people just click right through it.
With cameras in particular, most of them use some sort of card, whether its compact flash or SD or whatever the flavor of the moment is, and you spend $15 on a card reader (which is waaay faster than hooking the actual camera up in transfer speed) and the camera should never touch the computer to begin with.
So in summary:
1. If you are going to buy a computer, the most amount of risk for overpriced, underpowered, filled with bloatware option is to walk into a local store and buy what they have sitting there. Ordering from Dell or HP custom is a better trade because you have some control over configuration, and building your own is best.
2. Sony is the devil
3. One doesn't need the software that comes with consumer electronics in general, most of its built to steer you towards industry partner products or buy accessories for the printer you will likely never use. Or its filled with adware.