I use miniDV tape. It stores low-compression, high quality DV/HDV format video. My computers can deal with a firewire connection. Digital tape is an acceptable - and affordable - long term storage solution. I do not reuse tapes so I have original video from years' past and even archive final edited projects out to digital tape. Yes, I have lots of tapes - all clearly marked and stored in a cool, dry environment.
When I move the flash memory, it will be because I have first invested in a multi-terabyte network-attached storage (NAS) solution that is configured as RAID1 so there are two hard disc drives in the NAS case drives with the same data. When one crashes, it gets replaced and re-mirrored automatically by the existing working drive.
If your computers cannot deal with firewire, then miniDV tape is not "Best" for you. Generally, adding an IEEE1394 port is easy to do - assuming the computer has an available expansion slot.
If you have no long term storage infrastructure to keep your video, then flash memory will not be "best" for you just as it is currently not "best" for me.
There are not a "ton of options" for camcorder video storage... In the less than $5,000 range, SDHC or ProDuo flash memory cards, digital tape (mini DV), and maybe a few hard disc drive systems (falling out of favor due to known internal hard disc issues associated with vibration and altitude).