The following comparison was written with diSPIM in mind, but the main points apply to all types of SPIM/LSFM.
Spinning disk confocal (SDCM) is just a massively parallel confocal implementation so it's faster but otherwise has the same characteristics as laser scanning confocal.
Light dose: diSPIM has much lower dose and hence less photobleaching/phototoxicity than confocal. Reducing light dose is the main motivation for most SPIM users.
Z resolution: diSPIM after registration/fusion has best Z-resolution (same as XY resolution). Next best is confocal, which in turn has better Z resolution than single-view SPIM.
XY resolution: confocal and SPIM are comparable.
Speed: SPIM (per view) and SDCM have comparable speed if SDCM laser intensity is increased to compensate for the ~3% open area of the disks.
Camera readout speed bounds the maximum achievable frame rate. For example, 512 pixels high ROI is 2.5 ms readout time for sCMOS. Allowing 2.5 ms illumination time results in 5 ms total per image or 200 frames per second. Using a cylindrical lens instead of a scanned light sheet can reduce camera overhead.