For organizing and storing your video projects over any period of time more than a year, it's almost impossible to do without Media Asset Management.
CatDv has been the leader in this area for years, it's powerful, but complex which is great for some and bad for others.
Axel AI has been a fantastic and more simple option than CatDV, but without all of the bells and whistles.
These two options are really the leaders when it comes to a vendor dedicated to Asset Management.
The other option is to use a shared storage product with an integrated MAM. You can find these with ProMAX, EditShare, SNS and Facilis.
As with many technology choices, these tend to be more limited, but are better integrated.
A lot of choosing the right system is really about how you archive. Integration between an archive and MAM is one of the most important factors in choosing the right solution for you.