I would also like to work on more fun stuff! My uncertainty is whether enough fun paid programming work will appear to fill the gap left by the automation of the boring stuff.

I think a lot of people here are more interested in questions like "how am I going to pay my mortgage in future?" rather than specifically whether the job title of "software developer" will continue to exist (which I agree it probably will).