I have two sewing machine stations in my craft room: one station has a rolling armless chair and the other has a dining room straight back upholstered chair that is no longer used in the dining room. After using both chairs, I have now have the dining chair up against the wall with the plastic bin holding the pieces of fabric from my latest project.
I move my rolling chair back and forth instead. Only wished I had hardwood floors in this former bedroom.
Rolling chair pros: adjustable height when working at different sewing tables, back support, lightweight,
The con's : rolling on carpet.
Dining Chair pros: looks nice with sewing room furniture and armoire
The con's: the seat height is the seat height, no adjusting, difficult to turn to grab a tool, need to pick up to move it, and no true back support
bottom line: go with the rolling chair.