I'm going to cover these a few questions/responses at a time:
Retention, archiving and retrieval have not evolved much IMO.
Are you referring to the VMS software or hardware solutions?
From a hardware perspective, we are talking about PC or appliance based video stream recording applications here. This is a very small technology category, so it is generally going to rely on technology that exists everywhere else first. At the end of the day, most systems are going to utilize spinning drives in a chassis, because that's all they need.
From a software or solution perspective, I'm not sure what a Linux or Windows-based VMS could do to evolve the processing of data streams to hard disk. One solution example is the rise of VSaaS manufacturers, relying on the cloud for retention, or a hybrid local storage with the cloud as long term retention (IPVM Directory of VSaaS / Cloud Video Surveillance Providers)
I would like to see a discussion about the state of storage in 2018. What solutions exist for storage in our sector? Archiving in particular. We require massive amount of storage 200 cameras and 3 months of reliable retention is not trivial. Archiving is another complicated issue at least from my point of view.
Have you experience issues with an existing installed system that has been prone to failure when trying to retain 3 months of video reliably?
This is where storage discussions really become relative. 200 cameras for 3 months to many people would be massive amounts of storage. I am sure there are manufacturers and integrators on IPVM that are managing 5,000-10,000+ camera systems that require a whole additional level of scale. More on this below.
Waiting to hear from the collective. Would like suggestion and experiences about strategies, brands, practices, etc ...
For that specific example, if I was looking at retaining 200 1080P cameras for 3 months, with a mix of continuous and motion recording, I would ballpark estimate between 200-300TB of storage. Depending on the physical architecture (multiple buildings, multiple campuses) you might look at 3 or 4 basic COTS servers, or surveillance-focused OEM manufacturers like BCDVideo (IPVM Profile), or Seneca can work with you to design a custom solution for your situation.
Higher up the market from a complexity standpoint, are storage vendors who may or may not have surveillance marketed offerings, but focus on VMware, all-flash storage arrays, video stream hosting, 3D CAD operation, etc. These are names you've heard of like Dell EMC or HPE, or lesser know, manufacturers (in the surveillance world) like Netapp, PureStorage, Nutanix, and many, many more.
To summarize it, I mostly I agree with where you're coming from, if you want your storage solution to be confusing, it's a pretty quick walk to get there. However, this could just be a walk to avoid and keep it as simple as possible.