If you count the PC Version on Max Settings then YES
Consoles?Not really

The PS4 Version is 900p right?The One has 720p with bad frames probably right?

Yeah everything under native 1080p shouldn't even get a chance to be considered "Best looking" Game in the PS4One Generation.
Killzone SF is the best looking "Next"(Current now) Gen Game.

Graphically impressive sure. Most though, hell to the no.

Mmmm... I don't agree. It isn't the best looking 8th gen game because I think there are games that look better. And it isn't the best looking 7th gen game because I think there are games that look better.

I remember thinking "Wow, this is kinda the best thing I've ever seen" when I first watched the KZ:SF reveal gameplay. I also remember thinking the same thing after seeing the BF4 reveal gameplay, so I think you're right. I'm comparing PC footage to console footage, though, so it's not entirely fair.