It's too unnatural in my honest opinion and I have had some bad experiences with stupid deaths caused by bad and glitchy camera angles when playing in this perspective in just about every game that has it.
And I don't know about ya'll but seeing a hundred-foot tall dragon close up in the first person is far more intimidating than seeing it from the third person.