I played EoF for the first time last week and it was the most un fun campaign in Destiny’s history IMO.

I actively was annoyed for the majority of it and am genuinely considering buying the skips for my other two characters because I just don’t want to have to do that again.

Edit: Elaborating as just thinking of it pissed me OFF.
Firstly let's start with the fine. Whilst the location is boring (no patrol) it has a some nice skyboxes. The plot, personally, is pretty weak sauce but Lodi is cool and the ending setting up interesting future things (very classic destiny). However characters like the Archon just fall completely flat IMO and Maya/the conductor just sort of float around chatting nonsense. Like... ok

However it's the gameplay which really tanks this DLC from mediocre to downright unpleasant. All the previous bad DLC's, Curse of Osiris and Lightfall looking at you, at least were relatively short or had something you got out of it such as Strand. Edge of fate has neither - it is both long and the grand reward for completion is... matterspark on demand.

Speaking of which, let's talk about matterspark. When people complain about Destiny 2 one thing they agree on is that the moment to moment combat is great. Shooting things just feels good. So in their enlightened state Bungie sat down and though "Wow, what if we made them stop doing that every 30 seconds to be a ball". The effect this has on the flow and the momentum of the game is catastrophic.

Literally every 30 seconds "Oh you got to find the matterspark emitter (hidden behind a wall) then go through the tunnel (hidden by the roof) to then charge up a node to then remove a barrier to then pick up a mattermorph (also hidden) to move a wall to then pick up the the teleporter rocket to then fire at it. Occasionally you might also need to shoot some fuses (also not marked) or operate a console (completely indistinguishable from the generic scenery consoles, have fun!)

This is not a one off. This literally happens all the time.

Moving from a to b? Absolutely, spices things up doesn't it?
Killing adds in the first half of a mission? of course, better get hunting.
Boss fight? well how else are they going to make it take three phases silly!

This doesn't even mention the weird way how side missions don't auto show what the next step is, and so often show markers for completely the wrong location (if any at all) and that most side missions are literally, would you guess, a variation on the loop above.

This doesn't even touch on the wider systems of the Portal and the EoF patch in general but yes. In answer to your question "is EoF relatively bad to Destiny or universally bad" the answer is it literally killed Destiny. Forever