The only limit to how strong you can make a roof is really money. If you space joists or trusses half as far apart you will about double the max snow load.

At a certain point the problem stops being the roof, and starts being subsidence of the ground under the increasingly-heavy building.

That would be a LOT of snow.