It's a matter of different opinions, simply. To me, it does not look ridiculously fun. It looks like something mindless that might be fun for a short while. I take a game with great characters and story Before that, and while it's too early to judge (just like with The Order), nothing of that in SO has attracted my attention at all.
Yes, The Order 1886 so far looks pretty stale gameplay wise. But so would a game like Killzone 2 look as well. The Order 1886 looks like it will have an interesting story with cool characters, which Sunset Overdrive looks like it won't
In my opinion. As I said, it's a matter of different taste.
Also, I think it's funny how you judge me as someone who only wants "dark and broody" in Everything simply because I don't like how Sunset Overdrive looks. I love me some light hearted stuff, but from what I've seen, Sunset Overdrive doesn't hit the right spots. It looks light hearted without heart.
I'm a huge fan of the first Crash Bandicoot games for instance, so I can definitely appreciate light hearted and cartoony games. EDIT: The Super Mario games are other prime examples of that.