Is this not something everybody wants to some degree? Maybe not to the extreme of Akaky, but of course I like being useful. I like solving problems. I like making things that people use, and love to use.
It's not always healthy; at my current job (started 8 months ago) I see tons of issues to fix. Some of them are explicitly mine to fix, some close enough to my area of responsibility, but some of them are well outside it. And I'm annoyed that nobody has fixed these problems, because everybody is aware that these are problems. But the entire way the organisation works, seems designed to make it as hard as possible for me to fix them.
I'll probably burn out and leave in a few months to do something I care less about.
I think it depends on the person, I've had coworkers who struggle or don't enjoy solving problems. I enjoy solving problems at work so much that I find myself doing it on nights and weekends. I've also got an unhealthy mindset that I'm not going to let the "computer" win.
Seeing things being broken but not being fixed is a real source of frustration. The tricky thing in my experience has been figuring out which are issues that nobody bothered to fix and which are issues that seem simple but require huge changes to fix.
The day-to-day gets so much better when you can do a few of these fixes every so often, after a few months it really adds up when you compare to how things used to be.