Graphic mods ?

Hello Guys i always see people with really good Graphics that almost look like real life ? I assume these are shaders and mods. How can you download them has someone done this before ?