With some tweaking and practice it works perfectly. The exception being menus, which are best navigated with a mouse (can use controller but it's awkward).
You have to use a 3rd party application. I use XPadder. There are other options. Various guides and profiles for ESO via controller are available on the web, and this forum, if you search.