It sounds like you'll need more than one compressor to fill your needs. For carrying in a jeep, a regular 110 won't do you much good unless you have an inverter, plus they're kinda bulky. The 12V compressors don't come with an air tank and have a low CFM, so their pretty good at inflating tires, but not much else. Look for the Masterflow MF1050, it's what a lot of off-roaders are using and gets really good reviews, and is affordable at around $50 (similar ones are about $250+).

For general around the house use, get the largest and best one you can afford. After buying one, you will find other uses for it. Even just for using an air hose, the larger the tank, the longer you'll be able to use it without it cycling. Those smaller compressors are ok for occasional use, but if you have any thoughts about running air tools, spray painting, or pressure washing they will be underpowered. They will work, but you'll you have to do everything in short bursts (i.e. work for one minute, wait 3 minutes for the pressure to recover). It will get really annoying after the first time you have to do that.

Also, like eugene said, spend the extra money for a quieter compressor, it's definitely worth it. It might not seem a big deal, but having to work next to a noisy compressor is a real pain. I have the 2 hp 30 gallon craftsman professional series, it's good, but if I were to do it again I would have gone with a larger tank and get an upright one to conserve floor space. I use it a lot to work on cars and general use. With the air nozzle, it's ok, but if I'm doing a lot of blowing, I still have to wait for it to cycle (maybe every 3-4 minutes). Same thing with spray painting. For air tools that's about the smallest you want to go. Just make sure your electrical outlets can handle it, mine already blows fuses once occasionally, a more powerful compressor probably wouln't work for me.