You know, I'm glad you brought up Andross from SF64, my biggest cardiac shock in any Nintendo game, as an example. Every time a "scariest Nintendo boss/moment ever" thread pops up, I bring up the first time I confronted Andross as a kid. Almost 30 years later, I still have to mentally fortify myself to face him, especially the brain.
But I'm glad you brought him up and posted a video because he further proves my point. Look at every iteration of Andross after SF64. Even though you face his giant disembodied head again in SF Assault and SF0, the stage, atmosphere and presentation is FAR less creepy and unsettling in those later games.
Let's compare Andross 64 to Andross 0
Since they're both remakes of the original Star Fox, or at least pretty much follow the same story
1. When Fox is flying down the tunnels to face Andross in 64, the feeling of isolation and loneliness is hammered home, with only the voice of Andross to taunt him. This is after spending the whole game with your wingmates to remind you that you're part of a team. In SF0, James McCloud appears before the boss fight to help guide Fox. This completely changes the mood from one of dread to one of encouragement.
2. The tunnels themselves in SF64 were a drab brown and and rusted orange. They're brighter and more colorful in SF0.
3. In 64, when you reach the end of the tunnels, you fly into an all black abyss... a beat passes, and then you see a gigantic silhouette... as you're trying to make it out, Andross suddenly appears as your ship FLIES RIGHT INTO HIS FACE AND LAUGHS AT YOU WITH THOSE GIANT RED EYES STARING YOU DOWN. Resident Evil ain't got shit on SF64.
In SF0, you do have a closeup of Andross taunting you, but it's during a cutscene to hide the level loading. When you get control of the Arwing, there's a barrier between you and the giant head. You have plenty of time to get your bearings.
4. After you defeat the giant head, you either get a giant robotic skull that looks like it belongs to Satan trying to eat you. And if you don't hurry up and kill it, it can. Or if you're playing the true final boss, you have to fight a brain and two eyeballs in a a hellish arena. After you beat Andross 0, he does try to eat your Arwing, but he looks more reminiscent of his original form in Star Fox SNES. Not nearly as scary as the skull of the Robot Devil from Futurama.
I will remind you that SF0 is either a remake of Star Fox 64, or they are both remakes of Star Fox SNES. So here is further precedent that when Nintendo remakes non-horror games, it fixes characters and scenes to be less horror-inducing. The N64 era was a different time.
So we've kind of derailed the thread. We should probably get back on topic now.