I know you are against programmable logic but 14 $ plus VAT for a puny 2 kBytes SRAM is wasted money. A small FPGA like a Max10 with 2 K LUTS can give you dual ported RAM for far less money... or a MachXO2 for like 6-7$.
I don't remember who posted the Apple 2 Book in the other thread, but it is a very good read, specially well described is how to do video output using alternating clock phases. You need many muxes and clocks and so on. It is a discrete implementation after all.
Maybe you quest for the best video generator in terms of logic utilization, coolness factor or easiness of build contradict the point of the exercise: get the video going. One can improve (maybe) later on.
What exactly do you want ? remember that you 6502 can only address 64 kBytes at once.
- Text output ?
- Graphics ?
It doesn't matter, the point is how do you access video memory. Odd/Even phases are a good idea. Delayed writes are another, you can also duplicate the RAM and write to both RAMs but read only from non-video RAM then your video generator can run asynchronous from the main processor, a kind of Dual ported RAM on the cheap.
You could also use another processor to generate the video signal. For instance, a couple of times I used a parallax Propeller (it has 32 kBytes of internal shared RAM and 8 RISC cores, one for video and the others to service your write request and other things). It needs buffers for 5->3.3 V, but it works and it is a 2 chip+crystal (5 MHz) solution. Can give you many text modes and graphic modes. But it is kind of cheating

.
I have 3 retro projects that stopped on the how do I do video ?. I think that a FPGA is an acceptable solution, but I don't have the optimal board... but I have nothing against a Propeller doing the video output.
Look here for a 68k+Propeller that I did some years ago (I would use a couple of 74LVC245s today instead of resistors):
Video output is 256x256 with 8 colors or 512x256 with 4 colors in a 640x480 mode, if I remember correctly:
https://github.com/rosco-pc/propeller-wiki/wiki/pPropQL