You can get 900 MHz designs on FPGAs, but yes you need very good engineers and patience to get that.

Yes SRAM is limited but that's more of a ram-process limitation than a limitation of FPGA