Here’s someone who’s artwork is quite inspiring. His work is what you would see from an art department of a production film. You can see character designs, set/location designs, vehicle concepts, etc.
Sometimes artists are given a vague concept, with which they can “run with” and come up with inspiring pieces that further develops the storyline.
On the other hand, sometimes a movie script is very fleshed-out, with lots of details, and the artist is asked to visualize what is written.
All in all, it seems to be a very rewarding occupation.