Has anyone with a camera ever deliberately wanted a lens to have chromatic aberration?
You said it yourself: these are creative tools people deliberately choose for stylistic reasons. I have a couple junk lenses I use specifically because they have chromatic aberration and other imperfections.
Photography, however, is a very different beast than video games. I will never use chromatic aberration or film grain in a game, despite enjoying those effects in photos.