Automation could be an opportunity to focus on more meaningful work. It could also lead to more "bullshit jobs". Which one is it?