Most of these cinematic effects are not so bad when used in moderation. But when the chromatic aberration looks like a russian camera from the '70s, or the lens flares makes you think the game was directed by Jar Jar Abrams, that's bad design. And sadly, that's like 90% of the games that try to look realistic.

And I haven't seen anyone mention the worst of all: vignette. That's one that never, never works.