I guess you'd probably want a mixture of sequential and random. Sequential would be for reading/writing a big file or big chunks of a file at once (such as a video), whereas random would be for jumping around between files (which can happen even during a sequential operation as a temporary interruption). But, for example, if you are using the JpegFolder module, it's definitely a mixture of sequential (to read one file) and random (to go to the next file, which might be on a different part of the drive).
Also, it depends on how your operating system handles things, but many times, big files aren't stored contiguously. This is called "fragmentation" -- you've probably heard of it. Fragmentation results in the need for random seeks, so unless you are always defragmenting your drive, it's possible that one video file has different chunks in different places on the drive.
Overall though I wouldn't worry too much... pretty much any SSD is better than a traditional hard drive. If you've never booted Windows or OS X from an SSD before, you'll be amazed how much faster it is.
Once a video is opened, loading into GPU memory (Eric can correct me if I'm wrong) will handle efficient playback.
The video
decoding takes place on the CPU/GPU, but the
loading still happens from the drive, because videos are usually too large to fit entirely in memory. During playback, the drive is accessed quite a lot -- pretty much every video frame (or at least small groups of frames). An SSD always makes video playback faster, especially when playing multiple videos at the same time.