I'm in the same historical boat as you. Arena was one of my first games on my 486. Here's my take.
Starfield is Skyrim in Space with Daggerfall's procedural generation. It may not be the perfect game (or for some people, even a good game), but it is the close-to-ideal Elder Scrolls experience in space.
Honestly, the only thing keeping me from even checking it out is that it sounds boring
I tried a Daggerfall playthrough where I went town to town looking for loot and doing nothing else. It got boring because the towns all started to look alike. So I stopped and just played it how it was meant to be played.
There's no "boring" take if you ignore the procedural filler content and outpost system (which Bored me in my last FO4 playthrough) and focus on the storyline and main areas. The other stuff is all there for those of us who enjoy mission-fun. I LIKE pirating ships again and again, but maybe you don't. Literally the boring complaints come from the fact that they gave us Daggerfall-level places to explore, with Daggerfall-level repetition.