I'm sorry they're moving in a direction you don't want. You should probably skip this one. As far as Ragnarok having zero tension, I thought the scenes featuring Hela garnered some decent tension/stakes: When she destroys Mjolnir fairly easily, that was pretty crazy. When she disposes of countless Asgardians at will, it was pretty heartbreaking. The fight on the rainbow bridge featuring Hulk and Hela's giant hound was pretty suspenseful, not to mention when Thor shows up after harnessing his power more effectively (pretty amazing scene there). Then, the ultimate escape on the ship + the destruction of Asgard and Hela.
The movie definitely leaned towards many funny moments including one of my fav MCU lines ever ("We're friends from work!), but some serious stuff definitely happened. It clearly stands out from the rest of the MCU films in style and tone, but it worked very well for me.