I always thought of him as a divine who manifested himself as a man to interfere with mortals and then reascended as a divine somehow. Netherless, his legacy is shrouded in mystery, but his actions and impact on Tamriel can't be denied.
Quite a pathetic god in my opinion.