...and don't get an ECS motherboard as I've heard that ECS is poor quality.
Yeh, this is practically an urban legend.
The fact is that they are one of the largest board makers in the world. If you buy a name brand box ready-to-go, the MB could well have been made by ECS. Again, if testimony counts, I have bought several ECSs as well, and no complaints.
Regarding the main point of the thread, I have been mulling over a modest video upgrade myself and pouring over the latest ads. For an AGP solution, the 6600gt ($120 w/rebate) might be the max to be considered now for an AGP system. In a month or two, the 7600agp will be available for ~$200 or so, and that may just be the end of the line for AGP as a gaming platform. That level of performance, though, would suite the needs of many budget guys for quite a while.
Beyond that, I agree that a PCI-e board is justified. And that is because all the new big, bad video chips ARE PCI-e chips.