The iPad 9.7 is not worth it mostly because the screen is vastly inferior to the other models since it's not laminated. As a result, it makes it look cheap as iPhones since iPhone 6 mostly have laminated displays and I am used to it. In my opinion, a used 9.7 or 10.5 Pro for a little more compared to a new iPad 2018 9.7 is a better value for the value added feature it provides such as smart keyboard support, True Tone, laminated display, better cameras and quad speakers. If you have a bit more money, an iPad Air 3 is a good value if you want something new with a recent processor. Also, I highly doubt Apple will put a laminated display in the new budget iPad and will still use a screen that has a noticeable air-gap.
Since I now have an iPad Pro 11 256 GB, which I managed to get new in box for $745, which is $204 off what Apple currently sells it for, I would never go back to a budget iPad since it would be a big downgrade. Besides my Macbook Pro, I use it to do some productivity work as well, especially with the new features of iPadOS. I upgrade to the Pro 11 since I wanted something a little more powerful and USB-C support. I still use my 9.7 Pro, which is in every way superior to the iPad 9.7 2018.
In short, my recommendations are to get a used 10.5 Pro or 9.7 Pro. If you want new, an Air 3 is a pretty good choice for most people and will last longer with the new A12 CPU and 3 GB of RAM.