> What is the monthly cost of a Mac that can run games, run old software I require for work and hobbies and (importantly) isn't locked down in either hardware or software so I can use it for something completely different later in life?

Yeah, the Mac model for long term use is that you sell it later in life so you can get whatever it is that you need later in life. (Not saying that it is a good thing nor a bad thing).