I felt similarly about chocolate on steak but it worked surprisingly well.
I can't speak for the console version since I play ESO on the PC, though I've mostly been going at it solo style and even when I queue for a normal dungeon it can usually be completed without ever needing to chat. From what I've heard, coordination is a necessity for veteran dungeons and trials so I guess it depends on how 'deep' you want to go.
From what I can gather, if you play on console you do need PS Plus in order to play whereas you can play it entirely for free on the PC. Since it's F2P, there's an optional subscription that gives you some useful perks like bonus experience and access to a storage for crafting materials.
I'd say it's a good time to check it out since there's a new expansion out in early June. I mostly ended up playing it on and off over the years on the basis that it sates my thirst for exploration in a way that FFXIV simply doesn't. I'll say that the combat in ESO can be pretty clunky, though - FFXIV is much smoother and more polished on that front.
All in all, if you played one of the single player Elder Scrolls games and liked it then you'll probably feel the same way about ESO.