I think Bethesda are somewhat overrated but Arena, Daggerfall, Morrowind, Skyrim, and yes even Fallout 3 have all been pretty enjoyable to a greater or lesser degree and have one way or another avoided most of these problems. For example Morrowind and FO3 have level-scaling like Oblivion does, but they both handle it infinitely better and more sensibly from a gameplay standpoint and neither ever screwed things up like Oblivion does as standard.
You don't need to max everything out, but if you go level up through non-combat things like alchemy, barter, lockpick, or speech (ahahaha never use speech) then you're not going to be able to increase your combat stats like strength and endurance even remotely enough to keep up with the enemies. Just because you avoided it does not mean it is "inconceivably stupid" to fall victim to it, and not only do we have people saying this happened to them in this very thread, but it's also one of the foremost complaints about the game since it came out years ago and you can find an abundance of posts discussing it all across the Internet.
This I agree with, I want more magic making and enchanting options and MORE SPELLSMy main disappointment with the Elder Scrolls games is how they keep removing brilliant things. Where the hell is spellmaking? Why have my enchanting options been completely nerfed? Where have loads of spell types gone?