Hardness of approximation - additive error
The question is somewhat open-ended, so I do not think that it can be answered completely.  This is a partial answer.

An easy observation is that many problems are uninteresting when we consider additive approximation.  For example, traditionally the objective function of the Max-3SAT problem is the number of satisfied clauses.  In this formulation, approximating Max-3SAT within an O(1) additive error is equivalent to solving Max-3SAT exactly, simply because the objective function can be scaled by copying the input formula many times.  Multiplicative approximation is much more essential for the problems of this kind.

[Edit: In earlier revision, I had used Independent Set as an example in the previous paragraph, but I changed it to Max-3SAT because Independent Set is not a good example to illustrate the difference between multiplicative approximation and additive approximation; approximating Independent Set even within an O(1) multiplicative factor is also NP-hard.  In fact, a much stronger inapproximability for Independent Set is shown by Håstad [Has99].]

But, as you said, additive approximation is interesting for the problems like bin packing, where we cannot scale the objective function.  Moreover, we can often reformulate a problem so that additive approximation becomes interesting.

For example, if the objective function of Max-3SAT is redefined as the ratio of the number of satisfied clauses to the total number of clauses (as is sometimes done), additive approximation becomes interesting.  In this setting, additive approximation is not harder than multiplicative approximation in the sense that approximability within a multiplicative factor 1−ε (0&lt;ε&lt;1) implies approximability within an additive error ε, because the optimal value is always at most 1.

An interesting fact (which seems to be unfortunately often overlooked) is that many inapproximability results prove the NP-completeness of certain gap problems which does not follow from the mere NP-hardness of multiplicative approximation (see also Petrank [Pet94] and Goldreich [Gol05, Section 3]).  Continuing the example of Max-3SAT, it is a well-known result by Håstad [Has01] that it is NP-hard to approximate Max-3SAT within a constant multiplicative factor better than 7/8.  This result alone does not seem to imply that it is NP-hard to approximate the ratio version of Max-3SAT within a constant additive error beyond some threshold.  However, what Håstad [Has01] proves is stronger than the mere multiplicative inapproximability: he proves that the following promise problem is NP-complete for every constant 7/8&lt;s&lt;1:

Gap-3SATs
Instance: A CNF formula φ where each clause involves exactly three distinct variables.
Yes-promise: φ is satisfiable.
No-promise: No truth assignment satisfies more than s fraction of the clauses of φ.

From this, we can conclude that it is NP-hard to approximate the ratio version of Max-3SAT within an additive error better than 1/8.  On the other hand, the usual, simple random assignment gives approximation within an additive error 1/8.  Therefore, the result by Håstad [Has01] does not only give the optimal multiplicative inapproximability for this problem but also the optimal additive inapproximability.  I guess that there are many additive inapproximability results like this which do not appear explicitly in the literature.

References

[Gol05] Oded Goldreich.  On promise problems (a survey in memory of Shimon Even [1935-2004]).  Electronic Colloquium on Computational Complexity, Report TR05-018, Feb. 2005.  http://eccc.hpi-web.de/report/2005/018/

[Has99] Johan Håstad.  Clique is hard to approximate within n1−ε.  Acta Mathematica, 182(1):105–142, March 1999.  http://www.springerlink.com/content/m68h3576646ll648/

[Has01] Johan Håstad.  Some optimal inapproximability results.  Journal of the ACM, 48(4):798–859, July 2001.  http://doi.acm.org/10.1145/502090.502098

[Pet94] Erez Petrank.  The hardness of approximation: Gap location.  Computational Complexity, 4(2):133–157, April 1994.  http://dx.doi.org/10.1007/BF01202286