Android Tablet/iPad to replace laptop for on-the-go?

I currently have a Lenovo Thinkpad Yoga 2-in-1, but it’s getting sort of long in the tooth.

I’m considering replacing it with an Android tablet or iPad, primarily for the better interface, “always-on”/not having to wait for it to wake up, and the better battery life.

I tried a Dell 5290 detachable, but it didn’t really solve any the problems, although it was very slightly more portable.

Has anybody replaced their laptop with an Android Tablet/iPad? How did it work out? Was there any desktop software that you just couldn’t live without that made you switch back?