I had to do a lot of reading to decide what to do here. There are a lot more considerations than I expected.
Aside from price, I don't see much reason for wet cells in automotive use so this is all based on AGM batteries.
You have to consider your intended use, type of isolator and charging system.
Intended Use
To make best use of the capabilities of various types of batteries, you should go with one cranking and one deep cycle battery. Both would be the largest you can physically fit in your battery tray. One would be a cranking battery with a high CCA and the other would be a deep-cycle battery with no rating for CCA. The cranking battery would have a high discharge rate to support your starter while the deep-cycle would have large plates that are better for deep discharge / charge cycles.
Group 31 size AGM deep cycle batteries are often used in big power supplies (UPS, etc) and in competition car stereos. For this purpose, they are better and cheaper than the hybrid automotive batteries sold by Odyssey, Optima, etc.
Type of Isolator
Your isolator may be wired such that your starter can draw from the auxiliary battery if the main battery is low. This means that your secondary battery might be tasked with cranking. In that case, you would use a hybrid cranking / deep cycle battery on the auxiliary side.
This gives you the advantage of additional capacity should you need it to start the engine but at the downside of using a hybrid battery rather than a true deep cycle battery.
A hybrid can handle fewer charge/discharge cycles than a deep cycle battery. This makes having a good charging solution important.
Charging System
Alternators are pretty bad at charging batteries. They are dumb devices and as a result, don't charge AGM batteries completely, even under ideal circumstances.
If you go with completely isolated batteries (one for the vehicle, one for the house), you might choose to have a smart charger draw from the vehicle battery/alternator to charge the house battery for you. Then you can have a true deep cycle.
If you have a hybrid, it would behoove you to look at a solar charger. Hybrids can only handle around 300-400 deep discharges. Since the alternator is a poor charger (and is likely not running while you're discharging the battery), it makes sense to harness the sun when it's available and only rely on batteries when it's not.
100 watts of solar power and a decent charge controller will keep the house battery charged even while running a small fridge. By avoiding deep discharges, the hybrid battery lasts a lot longer.
Fuses
Most people don't fuse their automotive batteries but I think we could learn a lot from marine systems.
WIRE
I'm planning to add 250amp ANL fuses on my 00 awt battery cables & starter.
In the End
Since I'm using an isolator that allows the starter / glow system to draw from the aux battery (parallel batteries) I opted to stay with a hybrid deep cycle AGM battery. I am, however, upgrading from the Optima to a Sears Diehard Platinum PM-1. I'd wait for the Optima to fail but who knows when that will happen, so I'm upgrading pre-emptively. Not because I'm concerned about reliability but because I want the extra 45AH for a trip.
To keep the batteries charged, I have 100 watts (two panels in parallel) with a 10amp controller permanently mounted on my roof (TBD). This should allow me to run my aux load indefinitely, without starting the engine, provided I get enough sun.