If you are looking for long-term reliable drives for storage of data such as video streaming, HDD will almost always be the way to go since the bit rates are low (unless you are recording from many different streams at once), and the data itself is typically accessed linearly (i.e. this isn't a database where you might be joining different tables together to grab different "random" located data saved across the drive at the same time, but instead will typically be needing the next few frames of data corresponding to the next second or two of video from the current timestamp).
Given the above that we are then looking for HDD storage, I will usually start with checking out backblaze's latest hard drive reliability statistics. They have several hundred-thousand hard drives in operation that they monitor and track things like failure rates and publish it quarterly/yearly, and look at the top couple reliable drives in terms of failure rates, and compare those to see which might be best for my uses.
Link to backblaze's 2024 yearly statistics:
The 2024 Year End Drive Stats Report is here. See the the latest annualized failure rates and data insights for the Backblaze drive fleet.
www.backblaze.com
Given the above, I would look at 16TB WDC WUH721816ALE6L4 or 12TB HGST HUH721212ALE600. Unless you need significantly smaller drives. Both of those drives have very good reliability rates, and are traditional PMR style read/write (no shingled or similar where a buffer is needed for writes as the storage requires multiple cylinders to be read then written/over-written, etc., and can/will run out of the buffer if there is constant stream of writes being sent to the drive). These have firmwares that are optimized such that they can be used in RAID controllers and systems, and are designed to run 24x7 with high workloads (500+ TB writes per year) with 5 year warranty. Also note that WDC bought HGST and the newer 16TB drive is simply the newer family of HGST drives under the WDC brand.