I usually use smaller canvas sizes for smaller pieces/ personal art. I prefer smaller canvases because I find them easier to work with since I can omit the finer details and don't have to worry about it since it's personal art. A lot of art I draw on a small canvas are just doodles/ sketches or other stress-relief art.
For commission/ trade work, I do use a larger canvas size so I can put more effort into details, and the pixels don't get all wonky-looking whenever I need to transform lineart. Lineart is more tedious on a larger canvas since it requires more fluid strokes, and I still lack the control for it, but I find the results are more satisfying. That being said, a smaller canvas is easier on my body (but the resulting look not as satisfying) which is why I use them moreso for personal art than paid work.
In terms of receiving/ viewing other artwork, I'm pretty indifferent on whether or not it's on a small canvas. As long as the end quality is nice, I don't mind either way.