If you dont want to learn a lot first you'll have to stick with Shooters
Even with the best mods availabe AND scripting talent it's not gonna be somewhere near Oblivion, Stalker or what you see in any MMO.
But you could get somwhere close to "Dark Messiah of Might and Magic" p.e.
You can also check out Fantasy mods made for shooter games like Doom3, Unreal or Quake. That might give you some inspiration how to make fantasy without extensive dialogue, questing, inventory rummage and crafting.
In case you find my grammar and spelling weird ---> native German speaker ^^