The other day I had to install an SSD (a sandisk SSD plus 240GB, SATA3) on an old 775 core 2 rig that needed a breath of fresh air. It had an ASUS motherboard with VIA chipset, the southbridge was the VT8237A, it worked without problems.
Capped at SATA1 and no AHCI it still gave quite the speedup.
At least the SATA controller in my 2007 Gateway laptop met SATA-II specs. I'd mentioned my "upgrade" for the E475M lappie several times over the last year. It came "refurbished" with a 500GB WD Blue 2.5" drive, and only 2GB of SO-DIMM.
I found the 2x4GB SO-DIMM kit that fit it, and then I replaced the HDD with a Crucial MX100. That led me to purchase a 3-PC license for Romex Software's Primo-Cache, initially for use on the lappie.
It all worked fine. Some folks may be averse to the caching solution. Certainly, the SSD performed pretty well without it: the bench scores showed seq-read at ~250MB/s. Obviously, everything else was somewhat crippled by the SATA controller.
An SSD operating in IDE-mode or as SATA-150 may still provide a speed-boost. Personally, I draw the line at SATA-II, and only for something like an aging laptop. If I want to use an SSD in an old LGA-775 system with SATA-II, I'll buy a separate PCI_E controller for SATA-III. There's even a drawback with that, if the motherboard only features PCI-E v.1.0.