Another test:

NetBSD 1.6_STABLE with Sony DCR-TRV430E works, somewhat.  I can read
images off the memory stick, but mounting and probing the camera
take a long time (observe the timestamps):

Jan 14 14:41:36 pyy /netbsd: umass0 at uhub3 port 2 configuration 1 interface 0
Jan 14 14:41:37 pyy /netbsd:
Jan 14 14:41:37 pyy /netbsd: umass0: Sony Sony Handycam, rev 1.00/3.00, addr 7
Jan 14 14:41:37 pyy /netbsd: umass0: using RBC over CBI
Jan 14 14:41:37 pyy /netbsd: scsibus1 at umass0: 2 targets, 1 luns per target
Jan 14 14:41:37 pyy /netbsd: scsibus1: waiting 2 seconds for devices to settle...
Jan 14 14:41:39 pyy /netbsd: sd0 at scsibus1 target 1 lun 0: <Sony, Sony DSC, 3.00> SCSI0 0/direct removable
Jan 14 14:41:50 pyy /netbsd: umass0: CBI reset failed, STALLED
Jan 14 14:42:23 pyy last message repeated 3 times
Jan 14 14:42:34 pyy /netbsd: umass0: CBI reset failed, STALLED
Jan 14 14:42:34 pyy /netbsd: sd0: could not mode sense (4/5); using fictitious geometry
Jan 14 14:42:34 pyy /netbsd: sd0: 3952 KB, 3 cyl, 64 head, 32 sec, 512 bytes/sect x 7904 sectors
Jan 14 14:42:49 pyy /netbsd: umass0: CBI reset failed, STALLED
Jan 14 14:43:22 pyy last message repeated 3 times

Here I tried to mount sd0:

Jan 14 14:43:33 pyy /netbsd: umass0: CBI reset failed, STALLED
Jan 14 14:43:33 pyy /netbsd: sd0: could not mode sense (4/5); using fictitious geometry
Jan 14 14:43:33 pyy /netbsd: sd0: no disk label
Jan 14 14:44:03 pyy /netbsd: umass0: CBI reset failed, STALLED
Jan 14 14:44:36 pyy last message repeated 3 times
Jan 14 14:44:47 pyy /netbsd: umass0: CBI reset failed, STALLED
Jan 14 14:44:47 pyy /netbsd: sd0: could not mode sense (4/5); using fictitious geometry
Jan 14 14:44:47 pyy /netbsd: sd0: no disk label

Mount completed, I did 'ls' and 'cp' to get the files, when umounted sd0.

Jan 14 14:46:12 pyy /netbsd: umass0: at uhub3 port 2 (addr 7) disconnected
Jan 14 14:46:12 pyy /netbsd: sd0(umass0:0:1:0): generic HBA error
Jan 14 14:46:12 pyy /netbsd: sd0 detached
Jan 14 14:46:12 pyy /netbsd: scsibus1 detached
Jan 14 14:46:12 pyy /netbsd: umass0 detached

Would be nice if this all didn't take so long.. :-)

  -jm

P.S. A Belkin USB hub works (gee!):

Jan 14 14:34:33 pyy /netbsd: uhub3 at uhub2 port 2
Jan 14 14:34:33 pyy /netbsd: uhub3: Texas Instruments TUSB2046 hub, class 9/0, rev 1.10/1.25, addr 5
Jan 14 14:34:33 pyy /netbsd: uhub3: 4 ports with 4 removable, self powered