I've got a project that does something like what you are after.
http://hamsterworks.co.nz/mediawiki/index.php/File:Dualhead_mcb_frame_buffer.zipIt uses the Spartan 6 Memory control block, but your design using SRAM will have much the same functional blocks
Application logic (here is where your 6502 can go) - at the CPU freq
/\
||
\/
One port on the Memory controller (which has built in FIFOs), bridging the CPU freq to the memory frequency
/\
||
\/
Hardened Memory Controller, running at memory frequency <==> DDR RAM - 16x @ 200MHz = 800MB/s peak
||
||
\/
Another port on the Memory controller (read only), which has a built in 64-word data FIFO, bridging the memory frequency to the pixel clock
||
||
\/
VGA Generator, running at pixel clock ==> Analog VGA out
||
||
\/
DVI-D Interface, running at pixel clock, 2x pixel clock and 5x pixel clock.
||
||
\/
DVI-D Output running, at 10x pixel clock (using DDR)
The priority on the MCB interface is set such that read-only port has proiority over the CPU inferface, allowing it to never get staved of bytes.
To implement this with SRAM the architecture will be similar, and your SRAM memory controller have a strong preference for keeping the FIFO to the DAC fuil over processing transactions from the CPU - even to the point of stalling the CPU interface for a long period of time.
Another technique I've used in the past is to interleave video and processor transactions, but it isn't very efficient for a few reasons (e.g. bus turnaround), so I don't think it will work for you at your desired resolution. It only really worked well for me with monochrome 1-bit-per-pixel display, as needed a read only once every 8 clock cycles, and such a design can really only be used with SRAM as the DRAM refresh cycles and row activations get in the way upsetting the timing, unless you can schedule the all for the blanking intervals.
However, a SRAM based frame buffer is a bit of a technological dead end - SRAM is very expensive per bit. You really need a design that uses a FIFO to decouple the output pixel pipeline from the memory controller to the DAC.
For your next design this paper has some interesting ideas on exploting the banked nature of SDRAM to give you full memory bandwidth most of the time :
http://ics.kaist.ac.kr/intjpapers/High-Performance%20and%20Low-Power%20Memory%20Interface%20Architecture.pdf