If you're lucky you have some unique, weird system you have to build. If you're unlucky you're doing something mundane you've done a dozen times before. I would think this would be the same with many programming jobs.

One time I was tasked with implementing a system that simulated traffic in a city for an open world style game. That was a really interesting problem that I enjoyed working on.