This is a pretty individual question.
I thought the same as you do now.
A bigger tablet was a bit better, but much more to move your arm all day long.
Best if you can test before buying.
I have a small Intuos pro for travelling.
You have to zoom more. If one need precision, I increase lazy mouse.
This way I am feeling fine. Other folks don’t need that.
One mate is just so good at stroking. Makes me mad.
So I went all the way from small to big to cintiq back and forth.
For me personally I found peace with an used old Cintiq.
Others don’t like that at all. Lost of workspace if you have an old cintiq like me not to mention.
I am saying that not to tease you.
I guess if I would have concentrated on one specific tablet, I would have saved a lot of time.
This way I was searching for the wonder tool forgetting that the strongest and easiest to be trained part is sitting before the tablet.
Try to test it before you buy.
Just to find peace.
Good luck.