Don't know what software support there is but technically it's possible. Way back I've used a SCSI HDD to transfer data to/from the PC with only a single SCSI bus connected to both computers. Of course both systems didn't know of each other, so I had to use a dedicated FAT partition and diskchange on the Amiga side after PC changes and vice versa with an undocumented Ctrl-C on the MSDOS side.
As always with SCSI you need to make sure that
- termination is proper (exactly two terminators on the the ends of the bus, active ones highly recommended)
- each device has a unique ID - this goes for the host adapters ("controllers") as well (I changed my 3000 to 6 with SCSIprefs)
The rest depends on what software you want to use.