If one of the factors underlying the OPs sentiment is that they don't feel like their work is particularly useful or meaningful (which I DO struggle with), these points address that head-on.
Sometimes political or budgetary constraints can prevent projects like these from finding legs, but good points.
Or pick a general boring thing and automate it away. Thats also hard.
Or perhaps enable non-programmers to write programs for their own problem domain without having to learn much (if any) programming, so you don't have to do the "boring shit". Hows that for a challenge? :)