Generally not lighter for the same size. But, if you're not stuck with the same size case, then sometimes you can find a smaller, lighter battery with the output you need. Advantage of the Optima (and other AGM) batteries is that the liquid isn't going to spill out. Also it can be put in the trunk without a vent.
So far my experience with the Red top (automotive) has been fine for a mild build street car. I picked the smallest size that exceeded OEM CCA requiments and was close to the A-h requirements. I've had it a few years. Starts after sitting for weeks, even in the winter and restarts in the worst summer heat (so far).
DECKA is locally made and another option if you just need a good strong battery. They make some AGM batteries (Intimidator line) and several grade of regular batteries (Ultimate, Gold, ?). The better ratings usually weigh more for the same case size. I assume that's 'cause there's more or larger lead plates inside.