Is Marvel's Midnight Suns a great game? I don't think so. I think it's tactics are fun and solid, but they take a backseat to the RPG and relationship elements. Your enjoyment of those elements rely far too heavily of your investment on the Marvel formula, and for me there just isn't enough of a meaningful pull to go through these laborious conversations for hours on end to have just a side of tactics. Your mileage may vary, but I feel that for many, this will be a game that goes down as an interesting experiment that will be copied by others, and those games will benefit from the risks that Midnight Suns has taken.
That might sound a little harsh, but in all honesty I wonder who I would recommend Immortals Fenyx Rising to. If you have children or young adults around you and you'd like to connect over a game that the whole family can play, this is definitely a safe bet. If you're not put off by the narrative that I've described here, and are looking for a decent time filler to round out your year that will put you inside a nice looking world, then yeah, this could work for you. However if you don't fit into those two groups, I think your time would be best spent playing something with a little more meaning.
I think Hyrule Warriors: Age of Calamity is worth your time, the only question is are you willing to push through its shortcomings in order to see that payoff? For me personally the answer was yes. For you – I say do some research before pledging your sword for the realm.