I read that it is possible to create a huge storage cluster using containers from different sites, and managing these resources using Openstack and shared as a single big repository.
So, in theory, it is possible to build based on single common architecture of sharing structure and have these available globally to all offices while having sort of a "redundancy" mechanism right?
All I need to do is to replace any failed hardware at any of the site office, and there should have a "auto recovery" feature in SUSE?
Any experts here can advise my understanding?
There are a lot of things at stake here, not just a matter of which Linux distro you use. There are large storage solution that can span across racks, across data centres even globally, but you will need to get yourself involved in infrastructure level complexities.
If you want, here is something I know which is a block level high redundancy large storage solution from Ceph. Go do some research on it

Ceph has been bought over by Redhat.
Making your storage solution globally available to the offices doesn’t mean they have to spread all over the world. You will get into latency and bandwidth issue which performance or availability will need to be sacrificed depending on how you segregate
Perhaps this is what you are looking for? SUSE enterprise storage - This is commercial packaging for Ceph.
Meanwhile I am not sure of your business use cases, redundancy, enterprising standards, however I would recommend that you will want to look at AWS S3 and Storage Gateway before you start at building your own storage solution.