The reason golf cart batteries are ''better'' is because have very thick plates and are designed for hours of heavy discharge each day, followed by a fast recharge in only a few hours each night (think about how golf carts are used). Thus golf cart batteries are a good choice for the type of use the ''house bank'' sees, only in reverse (i.e., heavy usage at night, and charging during the day).
That''s why you wouldn''t want to use a plain ol car battery for the house bank. It has thinner plates which is better for a heavy discharge lasting a few seconds, followed by a long period of slow re-charge.
In addition, golf cart batteries have a better ''bang for the buck'' when comparing $$$ per amp/hr with deep cycle marine batteries. The downside is you also have more weight and space requirements to contend with.
Whatever battery type you use proper charging is absolutely the key to extended battery life. As PaulB says, investing in a good quality multistage charger is more important than what type (wet, gel, AGM, etc.) of battery you use.