You'll probably be happy with the Red Top.

They are not as tall as a "Regular" 12v battery, so make sure you can still strap it down!

There have been some here who seem to chew through them pretty quickly, but I suspect it may have more to do with how they treat their equipment...
Apparently they don't like being baked, so make sure your hood still has a gap at the trim below the windshield, especially if your battery is at the back of the engine compartment.
My truck had a battery shield from Mitsu, and that may help with reflecting engine heat away from the battery.

I've run a red-top for ~4 years, and a yellow top for ~2 years, and both are quite fine. I switched to a Yellow top "just because", and put the red-top in my wife's car. The yellow top is much heavier (deeper), and supposed to be more suited to occaisional run down than the red-top. Both made a real difference at start-up, the starter really seems to kick harder, and the vehicles start much easier and quicker. That alone is a good reason to use them...

Used to use Sears Die-Hards, the ones with the highest amp ratings I could get from them, and they'd last an average 6 years.

But they didn't have the kick of the red/yellow tops.