What cameras-camcorders can capture to PC?

Hello, I have a question I can't seem to get a answer anywhere.

I have Canon SX110 IS, or Powershot G10 those compact cameras can capture to PC user USB photos by using canon spplied software or third party software as PSremote.

I do use those on my microscopes. Now my problem is that new cameras does not have this ability anymore.
So are there any other cameras I could use?

I also noticed that modern camcorders can take still pictures too. Some even claim being able to take 10MP shots.
The question is can they take those still pictures to PC via USB? I know remote filming is possible with Premiere or similar software, but how about still shots?