As a fellow new-SSD user I can say you have to look for the right one. All those cheap drives can be slower than standard plattter drives. You have to check the read/write speeds and compare to (say) a high-end velociraptor or something.
If you want cheep but still pretty fast, RAID a few velociraptors together. Just add an extra fan over them for heat.
If you want to go SSD, can't spend a total fortune, the best performance is probably the low-capacity Revo X2s. I've got the 100GB Revo X2. It's smoking fast! I have Aces High installed on it as well as Win7 x64. Film viewer installs with AH default dir, and film playback is fast and smooth. I forgot to move my scratch drive settings to my 1TB SATA drive so at first my video editing was freakishly responsive and fast (it was sweet!).
Win7 x64 boots in 18 seconds from POST screen to being able to click mouse and launch programs.
Down side is it is an investment, and 100GB is okay but you won't want to bog it down. You WILL need a backup drive for the mundane work.