The motion sickness only really comes into play when you are still and the environment you are in is moving... so moving around a game with a control pad whilst you stand still is horrendous - although you do get used to it after an hour a day for a couple of weeks. You don't get motion...
Will be interesting to see how light / small it is. The upcoming Quest 3 from Meta is far slimmer than the current generation, but still looks bulky.
I've got a Quest 2, and it's great but definitely a gaming device above all else. I have tried a few productivity tools, but it's miles worse...