Not really, on the project I'm working on right now most of my longer prompts seems to consume somewhere between 300k and 400k tokens (input + output) and I find that both Opus 4.8 and Fable 5 don't seem to get lost with that much context. At least the results still look good to me.

I don't think I've ever pushed past 500k though, it may well fall apart at the higher end of what is officially supported.