I don’t know about San Andreas, but the GTA III co op mod was something pretty special. It took the other players coordinates and assigned them to your last vehicle, which didn’t despawn.

There were no on foot player characters, but you could drive around together in a game with absolutely no multiplayer or online elements at all.