You don't have to automate all of it, just whatever parts you do not consider fun so you can get to the fun parts with less friction.

But I suppose it depends on what you consider fun. I genuinely know people who love to meticulously write many many unit tests. I think that's great as a craft, but you probably can not expect to get paid for it, similar to how you likely can not be profitable by selling handmade shirts now unless you are already independently wealthy and well known.