what you say is your bad personal experience with a early model of two decades ago probably used in windows 98
say that you can't connect a camera to a pc this days is like say that you can't use a digital camera
not gonna happen
we had a cellphone that when connected to pc did that, bricked, when taken to warranty it worked magically but we asked the guy to connect it to the pc, happened again
we left the store with a new cellphone without the problem
warranties have changed alot in the last decades, your recommendation is hard to consider