Leave it to KKRT00 to call The Order 1886's particle effects poor and cite only the weapons. Let's just ignore the volumetric particle system that includes depth fog into very expansive, distant environments, the smoke stacks, the weather, atmospheric effects on the ground, explosive clouds, etc. Also, I love how a game using Tress FX makes it "automatically better" then other games.
I think titles like Driveclub and The Order, along with Ryse and even moments within Infamous have achieved the look and feel of something that is offline (pre) rendered and playing back as a video. We may not get all the bells and whistles afforded by having petaflops of rendering power the Pixar, Dreamworld, Weta, etc. have, but we are at the forefront.
Games on PC how already been making headway into this territory as far as image quality and (high) framerate, but we will see more consistent high quality visuals on the consoles and then counterparts on PC later as the hardware is closed and thus QA is less of a headache then the thousands of modern computer setups.