As someone who's actually played both games: yes, the Sonic Forces trailer footage is at least as good as the actual gameplay footage, of not a bit worse given the loss in quality that tends to happen on YouTube. Forces is gorgeous game and, from a technical stand point, a better looking game than Odyssey. On screen, in motion, and in person, it LOOKS like a 1080p current gen game. 

Of course, having played both I also know Super Mario Odyssey will be a much BETTER game, but the fact that they managed to get this running on Switch at all is impressive, especially as other companies are struggling and making compromises to bring their own current gen games to the system.

Visually, Super Mario Odyssey will look better than Sonic Forces Switch. But that's a pretty typical story when it comes to exclusives vs multi platform games. Exclusives are able to put the time and resources into exploiting a console's power that a multiplatform game cannot. And in the case of Forces, it was made for vastly more powerful platforms first, and then the development team had to take that current gen tech and assets, and put them onto a platform they were not built for. I've no doubt that if this game was built for Switch, it would probably perform better. Sonic Lost World ran at 60 FPS on Wii U, after all.

The demo I played at E3 was certainly rougher. In addition to the frame rate and resolution stuff, it also has lower quality textures. That being said, the game demo was just as playable as the other versions, and for a Switch game it looks perfectly fine. And at 30 frames, it has the exact same frame rate as Sonic Colors and Sonic Generations.

The Switch is an awesome system, but is also a console running on a friggin mobile processor. XD If you want games ported, you're going to have to accept sacrifices like this. It's not a matter of devs being lazy. They just aren't literal wizards. Doom is making the same sacrifices. So did Snake Pass. So will literally any port of a 3D game.

Graphically, this game blows Generations away. At 60FPS the PS4/Xbone versions have twice the frame rate, as well,as higher quality character models and environments. Easily the best looking Sonic game ever made, at least on those platforms.

Unfortunately, the Avatar plays like crap regardless of platform, at least in the E3 demo.

The visuals on screen will be updated 30 times per second, while controller input will be polled 60 times per second; in other words, you don't have to wait for the next frame to arrive on screen for the input to be registered, so while you'll get the visual experience of a 30fps title, you'll also get the lower input lag of a 60fps title.

That's interesting. What other games have done this?

Odyssey runs 720 fp 60fps on handheld and 900 fps/60 fps docked. 

actual footage

trailer footage (probably worse than final footage)

What a load of bullshit.