I have to jump in, as this is always a fun one.
Someone mentioned that water would be a good brake fluid if it did not boil - true. It would also be a good refrigerant if it only would freeze a little lower. The point with the hydraulic fluid is, you cannot compress a fluid, so any will work.
Old (up to late 50s) Brit cars with Girling used seals made of natural rubber, and Lockheed fluid would destroy that rubber. Lockheed had already jumped into the 20th Century, and moved on to a synthetic rubber, so it didn't matter what kind of fluid. The DOT numbers in our country indicate the boiling point, and 3 is fine for street use.
Citroen used a mineral oil in their ID/DS series, which powered everything, including the brakes; but not in this country, where brakes were by law required to operate on brake fluid. Just like the old sealed beam law prevented us for a long time from having halogen bulb type lamps.
All you really need to know is that you don't have natural rubber seals (and if you do, they're already either ruined by synthetic fluid or dry rotted). Otherwise, use whatever you want.
In any case, change every couple of years, as brake fluid is very hygroscopic (not hydroscopic), and you want to purge the system of the moisture, not only to eliminate moisture that can boil, but to flush out the dirt that can eventually cut a seal at the perfectly wrong time.