Yellow top is a standalone battery, meaning in addition to the battery under your hood. Red top is what you would "replace" your stock battery with. Never seen the Stinger battery.
If you're looking to improve your electrical system though(ie. your lights dim) then I would recommend a bigger alternator over anything.
__________________
I got a dig bick. You this read wrong. You read that wrong too.