I have actually been working for a certain battery company for about a year now so I can give you a general idea of what to look for and avoid...
The main thing is that you shouldn't really perceive batteries by the name on the sticker, but go more by their overall design. There are a couple large companies that manufacture automotive SLI (Starting, Lighting, Ignition) batteries and do private labelling for what you see on the shelves.
Delphi, Exide, and Johnson Controls are the major players in the game. Optima was actually just bought by Johnson Controls, but I believe they were previously under Enersys/Hawker.
At work, I generally see many many varieties of batteries come in from failure due to mechanical issues or owner neglect. More than often, the ones that come in with problems seem to be the "maintenance-free" type that have permanently sealed off vent caps. I can't honestly give a specific reason, but dead cells pop up as the most common culprit.
Now, for a battery for your car, you'll be fine with a OEM match. Since you said you have a Honda, you most likely will need a BCI group 51 or 51R. You could very well put an Optima in there if you have the room, but unless you subject your vehicle to high vibration or long periods without activity, it's pretty much overkill.
If you're going to do some shopping around, try to take good mental notes on how certain batteries look. Remember if the vent caps are recessed or lie above, and pick them up to compare weights. Chances are if you spec out a battery at different stores, and it's built VERY similarly but differently branded, it's probably going to be the same thing. At that point you just need to compare prices and warranties to get the best deal.
Cheers
Will