Xilinx has comparison between components inside the same family.
Google words: "{Spartan6, Artix7, kintex7, zynq} family" should return the comparison between the components on the same family.
"{Spartan6, Artix7, kintex7, zynq} datasheet DC characteristics" should return the max. freq. speed of each component.
The max. speed depends much of what do you need, and how you will implement it. 500 MHz is not easy to reach, if you have a complex design. You can write a test code and synthesize it to have an idea.
I would recommend to have a look on Artix 7 and Kintex 7. But you told no project requirement beside speed (logic? price?)
Also, you should navigate a little across Xilinx website. There are lots of detailed and accurate information there.