The problem seems to be linked with Innisgreen and Sprucederry Grove, as that is the neighbourhood I have been playing in the most (it's where my sim family currently lives) and I have been experiencing all of my CTD while trying to play the game in that world.
I can play for hours on other lots and neighbourhoods, but the moment I try to play for more than half an hour in Sprucederry Grove, it becomes a real gamble if I can play for more than an hour before it just out of nowhere crashes. As a precaution, I have started to save my game in 20-minute intervals.
This CTD issue seems to be linked directly with live mode, as I can also leave my game idling/paused for over an hour of IRL time or spend the same amount of time in CaS and B/B Mode without the game crashing.
I am having this issue both with and without mods, so I am 100% confident there is a coding error/bug with Sprucederry Grove, which is causing the game to error out and crash with no warning.