I have had good luck with Walmart and NAPA premium in DD's. I run an Optima on the hot rod. First one before they had quality difficulties, second one apparently after they were fixed. Both have been fine. With battery in trunk, I do not want acid leaks. I also have had really good luck with OE batteries as posted.

As far as the off road part, depends on how hard you are pushing it. If moderate, a DD battery should be fine. If racing, jumping ect then agree an AGM battery would be better.