I think one reason the conclusion doesn't satisfy is because the question of "What do we do in a post-work world?" is horribly open ended. I believe the question is relevant as technology and automation increasingly penetrate manufacturing, business administration, and (soon to be) transportation to name a few.
To put it bluntly, for most programmers, it's our job to put others out of a job. The things we build make it easier to automate, streamline, and other buzzwords, which generally means that a company doesn't have to keep as many workers on the payroll. The business administration side is fairly decimated, and I believe the falling prices of 3D printers and robotized factories will lead to automated on-demand manufacturing. This means more people won't be able to find work, which will depress the demand for products. It's an interesting problem.
> shouldn't it follow that there are potentially a myriad of possible projects which might be amazing and worthwhile things to build, even if they obviously won't turn a profit?
Yes. I would argue that the artifacts of human culture (portraits, frescoes, symphonies, statues, etc), in many cases, have no obvious financial benefit at the time. They exist because they appeal to our aesthetic side and the creators lived at the pleasure of rich sponsors.
Many programs of the Open Source universe started as an annoyance or a fling without any thought of profitability. Several tech companies started as research projects or "the itch" with no money in sight. Much of our software is still built pro-bono by an army of volunteers.
In this way programming starts to mirror the art world. The mindset to adopt is to create for the sake of creating, and letting others critique the work. Think about a programmer version of art hostels in Paris of early 20th century. In fact, go watch Midnight in Paris and see if you can picture (hah!) programmers drinking and talking instead of artists and writers. There are programmers out there like that, like Mr. Bellard and his DIY cell phone base station [1] or John Carmack's Armadillo Aerospace [2]. They build for the sake of building something cool.
[1]: http://news.ycombinator.com/item?id=4469424
[2]: http://en.wikipedia.org/wiki/John_carmack#Armadillo_Aerospac...
For your second question, I can only assume that many entrepreneurs enjoy the challenge of building successful companies. Being wildly successful means they have additional capital and can chase larger and more complex problems. SpaceX comes to mind. Granted I can't think of a founder that was very successful start something trivial (I'm sure they're out there).