So my experience with storage on socketA:
First of all my goal is SSD, always. HDD is absolutely not an option, apart from may be testing. So i look at everything from that perspective. Noise and performance of hard drives is one thing i absolutely do not miss about old systems. Also vintage hard drives tend to have questionable reliability while new ones are overpriced and present the same compatibility challenges as SSDs. This is just a personal opinion though, nothing more.
I've had zero issues with nvidia south bridges integrated sata. I've plugged in random SSDs, old or new and random hard drives and everything always worked. On different boards. The only caveat is - better to not install the drivers, as those bring a bunch of issues, and use with "standard" microsoft ones. Performance is... ~110-130MB/s, which is actually quite good for this old hardware and can be hard to achieve on PCI controllers. I am surprised to hear about the issues on NF7 – S2G, this must be board or bios specific. This makes MCP2-S/R/GB quite desirable for me, because it represents pretty much the best storage performance/compatibility on socketA.
VIA = bad. As mentioned sata1 only so no SSDs => completely uninteresting for me. This ports might as well not exist.
Silicon image 3112/3114 = horrible, not only compatibility is questionable (some SSDs work, some do not), but also silent data corruption issues in some configurations. Completely useless and capable of causing data loss and random stability issues which are hard to troubleshoot. Never use.
So my take here - it is either MCP2-S/R/GB or no SATA at all (admittedly i have no experience with SIS chipsets). Obviously motherboards with better soldered discrete controllers may exist, but i've never practically used one. In case of no SATA - IDE-SATA adapters have worked flawlessly for me on socketA, with various SSDs. Both VIA(but newer ones - KT333,KT400,KT600) and nvidia. Performance is worse than with MCP2-S/R/GB, around ~70-90MB/s, but still good enough.
There are also PCI controllers which work fine with SSDs, and for me if other options fail this is the way to go.