1) Some things you absolutely need like Fleet logistics, planet settling techs and the upgrade to certain types of ships based on your battle preferences. If there are multiple stars you need to jump to them as well. Basic repair and air defense can figure in here as well.
2) I would consider those techs that allow you to get resources quicker, build things for less, cause population to grow are kinda in the second group.
3) Then there are the rest. It is nice to know when someone is jumping at you. There are the warfare techs like shielding and repair that are great to have as well.
4) Some of it is just candy for the last grouping like a Novalith Cannon.
For my two cents as a relatively new SP person I try to do most upgrades in the above order after I have sufficent fleet and types of ships for my purposes. Extra cash/resources available? Upgrade.
My last game was dramatically different than the previous as I just basically built fleets to Assailants with a few Caps/Destructors and took/held planets. Cash flow was not as great but I had fun.
Multiplayer I'm sure is entirely different.