I'd put money on 2028.... that is when production will once again equalize with demand for ram, getting prices of ssd/ram chips down.
Not because demand will be less than today, but because by then, production will have adjusted upwards abit more than currently.
That said, I still think a new PS6 or new Xbox will be expensive.







