Short answer: no.
Long answer: As much as I'd like to say Oblivion can make use of more than one core, the engine specifies only "multi-threading", which is possible even with one core (HyperThreading, anyone?). I can't find real evidence of Oblivion using a second core. Also, it multi-threads only for stuff like SpeedTree and Havok, none of which computationally intensive (just look at how a body falls at only a constant 1 meter per second)
Fallout 3 is multi-core capable, only the game engine itself is a bit outdated, so I think no huge boost in performance, but will help remove the wandering question "how the hell can an i7 struggle with Oblivion?"
Right. FO3 and FONV use over 40 threads according to take manager which is twice the amount of what oblivion uses. Oblivion came out right when dual core CPUs were going mainstream. Even in 2010 most games primarily use one core although the multicore speedup is much more noticeable now with modern games
Unrelated, but in the past I experimented with the threading options in the .ini file and it didn't do squat. Same with the fallout games. In fact in some instances modifying the .ini decreased performance (such as background loading which is endorsed by the tweak guide to reduce stutter when in fact in increases load-related stuttering cause the game loads assets while you are playing it instead of the loading screen)