Hello I would like some advise for my issues.

For some reason when I try go to Sanctuary and Red Rocket, the game crashes after few minutes. I have try many people's advise but none have proven be the key. So if anyone can offer advise, I would be very thankful. Thanks.

You should post your load order. Also keep in mind that sometimes game updates break UI mods, so usually a good way to start troubleshooting is disabling UI mods (this was the case with Automatron and more recent game updates and certain UI mods).

Since it's Red Rocked and Sanctuary, two of the most used settlements, are those two locations heavily expanded upon with buildings and stuff? Bethesda put in place some pretty restrictive limits on how much stuff you can build at a location but removing those restrictions and going completely overboard can have a huge impact on performance and even causing game crashes if your system can't handle it (usually it runs out of RAM/VRAM and crashes).

Another thing you can try is fast travelling to a nearby location (Concord or Vault 111) and approaching from there.

For troubleshooting purposes you could also try doing a dichotomic search: disable half your mods and see if it fixes it, if it does then it's probable that the mod(s) causing it were in the half you just disabled. If not, disable the other half instead. Once you know which half contains the problem mod(s) you can disable half of that half and doing it all over again (check which quarter has the problem mod). You can narrow it down very quickly that way.

Hmm you got my attention with game update thing. I try reloading the mods three times so can't be one of those.

I only used few settlement mods like Bat Settlement, the Turret mod, better beds, Impressive Vendors, and Happy Maker. Still could be that one thing with Automatron, any advise how I can reload it since I use Steam?

To check your game file integrity (including installed DLCs) you can go to your steam game list, rightclick Fallout 4 and select properties, then in the properties window go to local files and click "Verify integrity of game cache".

When you say reloading mods what exactly do you mean? Clean saves, redownloading mods,...?

Try disabling your mods see if it still crashes.

The last one, redownloading and thanks.

Another alternative is trying to load a older save and see if you can visit those places without crashing.