A larger texture file is going to consume more memory. I feel safe in saying that the texture would look the same if you just repeated in your paint program using a larger file size.

If you increase the detail of the texture while making it a larger file than I think that would be worth the extra memory usage. YMMV.