as for Fallout:Sonora, it appears you only got the unofficial translation of the game, not the game installation (which is in Russian) and which has to be downloaded from rutracker.org russian varez site. English Fallout2.exe 1.02d doesn't work since the game requires Russian executable in order to work, so you need the full game installer, you either get it from Nevada Band's site or from rutracker.org. since those games are distributed in a certain way, they might be considered piracy in western world, hence You won't find any direct links here to the installers.
As for Fo:Yesterday, it requires to copy Fallout2.exe from your Fallout2 installation ( a.k.a You must own a legitimate Fallout 2 copy to run the Fallout:Yesterday ). also in case of Fo:Yesterday there's also the need to rename the executable somehow, but i don't remember to what it should be renamed. Due to certain schizma in fallout community created by Youtuber Warlockracy, Fallout:Yesterday News are locked to Fallout:Yesterday's Patreon, and until the project is complete, there's unlikely any news or any new versions will be available publicly. All thanks to Warlockracy who managed to successfully anger Fallout:Yesterday's creator by widespreading misinformation that the project is a copycat of other productions, while it only used certain art as placeholders in early alpha releases until Hexer develops his own art, to replace the placeholders.