There's more LOL than that in the tech tree:
Horse Archer (Huns) -- Possible for an archer to ride a horse without knowing how to ride a horse.
Frigate -- Possible to build a ship that has cannon on it, without knowing how to make a cannon. In fact you don't even have to know how to make iron or bronze.
Artillery -- Possible to make a cannon with rifling without knowing about rifling.
Nuclear submarines - possible without Atomic Theory or the ability to locate uranium.
rather see Computers take a role more like Civil Service has (passive bonus, lots of techs requiring it, slightly higher in the tree vertically), since, you know, in real life they're kind of important.
I find it pleasing in those cases where the tech tree gets it exactly right: radio (both in itself and in Civ V terms as the tech that encompasses the invention of transistors) was probably the single most important technological development of the 20th Century, and there it is as the most crucial entry point to the Modern Era in Civ V. It would certainly be welcome if the game had a few more cases like that - though, as has been noted, Civ V generally does a better job than past Civ games; no wheel-less automobiles, and everything on the tree (except "Drama and Poetry") plausibly represents a technological or conceptual advance, unlike Civ IV's Divine Right or Meditation, or Civ III's Prophecy; plus, while a few abstractions like Philosophy, and developments in social organisation like Civil Service, are still there, "techs" like Monarchy, Liberalism, Republic etc. have been more appropriately assigned to other game systems, making Civ V's tech tree the first Civ tech system to try and approximate 'pure' scientific development.
submarines before Combustion. in this case i would argue, due to subs' being pretty powerful, that it's both bad gameplay as well as realism.
It's better realism than it is gameplay. Functioning submarines were developed by the American Civil War (and less effective attempts before that), a couple of decades before the development of the internal combustion engine. The submarine depicted in the graphics is of course fully modern, however.
In any case a better way to look at techs in Civ games generally is as abstractions representing a general period by one of the technologies most associated with it, rather than as that specific tech. So Combustion = period between around 1885-1914, for example.
GWB's are too powerful to be so easy to get with such minimal military investment.
Except that they have the same constraint as another powerful unit, the Frigate. You don't need Iron Working to build Frigates, but as pointed out you need iron. You can get GWBs without Biology, but you still need a source of oil, adding to the teching you need to do to obtain them.
In any case I think GWBs are about right power-wise for their era (both in reality, and in terms of their tech placement in game) - they're drastically less effective than the bombers you can upgrade to with Radar, and won't dent equivalent-era cities unless you have a lot of them. The power of early planes comes from the ability to stack lots of them - relatively speaking a GWB as an individual unit is less dominant than the frigate is for its era. And lots of planes require lots of oil and lots and lots of hammers.
BtS had a more balanced tech tree, and most of the techs and units have at least two prerequisites.
It was also verging on unreadable; as it was the game had to compromise and make sure that the prerequisites weren't very far from one another on the tech tree (had it had an Archaeology tech, it wouldn't have required Mining as a prerequisite), so that they could be mapped reasonably on the schematic.
I think a better approach would be to keep the Civ V (and Civs I-III) linear tech tree, but adopt the BtS system for buildings and units, as many of those had multiple prerequisites (which BtS didn't even try to map). In most of the cases discussed here, both gameplay and realism issues relate to the units found at certain levels (Flight without Combustion? Fine. A bomber that requires oil without Combustion? How does the oil power it, then?), rather than the actual tech progression.