You can't select a sensor with great confidence until you better understand the datasheets. You need to be comfortable with the main features involved.
Mechanical sensor is main error source: You need to read the datasheet of such devices VERY carefully. More so for parts like this than many others as much of the spread and offset in the data is due to the underlying mechanical sensor rather than the electronics per se.
Real requirement? Note that your requirement could probably be met with a quite modest spec device. I don't know what your peak g limit is, but say it was 0.1g. And imagine that you wanted to not be more than 10% wrong when you decided the boundary has been reached (0.09g to 0.11g). That's a 1:100 resolution of the actual data point so a device that was genuinely accurate to 8 bits = 1:256 would probably serve you well.
It's quite like that the ADXL345 that you have a sample of will do what you want but there are some things happening there that you need to be aware of.
Documented error sources:
The results you report seem to contain both scaling errors and an offset. Your reported range of -0.98g to + 0.9g = 1.88g suggests a mean value of 0.94g or 6% under (probable :-) ) g level where you are.
The centre value -0.04g or 40 mg (milli g).
Offset error: A look at the data sheet shows that the offset spread is about +/- 50 mg for X and Y axis, in excess of +/- 100 mg worst case for the Z axis and that the centre of Z axis is offset about + 20 mg at Vcc = 2.5V and -10 mg at Vcc = 3.3V. Wow! Clearly some calibration is required for a given IC and a stable Vcc looks like a very very good idea!
Gain error: Similarly (but not as severe) gain varies both with axis and between samples:
Nominal gain is 256 LSBs per g. This graph shows (apparently) that most common sensitovity bins are 254 and 256 LSBs/g but that samples of from 250 (-2.3%) to 260 (+1.6%) lsb's/g can be expected. Your 6% low value seems to be outside this spec
BUT there are various other things to consider as well. Rather than my wading through these at this stage, have a look at the data sheet and come back and ask questions.
How good can you get?:
For interest, the 2 axis ADXL213AE(is the most expensive Analog Devices accelerometer ) as assessed by Digikey 1000+ pricing.($20.66/1. $14.33/1000). Looking at its specs should give some idea of what is able to be attained. Parameter spread is similar to the ADXL34 (about $8/1).
The dearest Digikey listing, the 2 axis +/- 4G $89 VTI SCA1000 does not have a detailed enough data sheet to make comprehensive comparisons, but the +/- 60 mg zero point error over temperature (-40 ~ +125C) is perhaps better than but similar to the ADXL units.
Frank mentioned the L1S3H, datasheet here.. This does not provide the detailed distribution graphs that the ADXL parts do, but it shows a +/- 40 mg typical zero offset, which is of the same order as what is seen in other parts.
Best Answer
Gyroscope will be more accurate, but is highly subjet to drift, which is the reason why they are often used with an accelerometer and even sometimes with a compass.
Accelerometer alone will be slow.
I would suggest you watch this conference : http://www.youtube.com/watch?v=C7JQ7Rpwn2k