Energy return on investment (EROI) isn't a useful measurement. Hydro power tops your table, but hydro is only 6.5% of US power generation. Natural gas is a leading power source, despite being very average in EROI.
If there is one meaningful limited resource, it's money. Governments use a metric called levelised cost of electricity. This is a better metric because it accounts for all inputs (energy, labour, capital) all of which are limited.
Even this metric is lacking. Energy sources have many diverse factors which make them good or bad. Bio diesel produces a high-density highly-compatible liquid fuel, low carbon, is relatively low in air pollution, highly storable and domestically producible. None of these features are accounted by EROI, and most of these aren't accounted for by simple economic analysis.
Because most of the benefits are non-market, either environmental, political or geopolitical benefits, governments subsidise bio-diesel. Whether it's good for the country will require a detailed look at all costs/benefits, not just EROI.