Not that I know of, at least not in Photoshop (I don't have the whole suite). I have Photoshop 6.0, CS4, CS5, and CS6 on my Windows 7 workstation and I still get normal autoplay functionality when I plug my camera into a USB port.
One thing though... I normally disable a number of extraneous things Adobe installs (e.g., Switchboard, Service Manager, updaters, etc.) via Autoruns. I wonder if maybe I've avoided the problem you're seeing because I do that.
I'll be interested in seeing the resolution for this issue when you find it.
Not a resolution but I did find out something. I tried uninstalling CS5 and installed CS6 and it worked fine. So it's definitely a CS5 problem. I'm going to test other things out to see what the issue might be.
That's very interesting.
I used Photoshop CS5 when it was current, and I had no trouble then either (but again, I didn't have the whole suite).
I suppose it could be something Adobe's already fixed with the suite.
Best of luck getting to the bottom of the issue.