"Which brands have what it takes to keep us feeling safe and secure, a sound investment that isn't prone to failure?"
There's no guarantees on any RV, new or used, or any brand, make, or model. It's like buying a container of strawberries. They look absolutely magnificent in the store. Bring them home, put them in the refrigerator, and the next day they have 1/2 inch of mold growing on top of them. Next week, bring home another container of strawberries and they will sit in your refrigerator for 2 weeks and still look perfect!
The best advise possible for you now, is to encourage you to go visit the different RV dealerships in your area and start comparing them. Even if someone recommends a specific brand-model as being absolutely magnificent, the one you purchase might have been assembled on a Friday afternoon. You might get the "only" one with a defective refrigerator out of 1 million refrigerators installed, you may be the only one that has a window leak because the builder ran out of caulking in the tube and because it was Friday, decided to just skip that last inch of calking. It's because of this very thing that you really need to spend time visiting the various dealerships and spending time inside those campers. When you find the one that appeals to you, you agree to a purchase, then it's your responsibility to agree everything is OK with the camper when you sign the dotted line. Before you, you have the PDI (pre delivery inspection) and anything not right gets fixed first. (warranty work is such a hassle for RV owners, but on new units, it's almost always a given). If you know what you are watching for, because you've spend the time and energy comparing hands on with different campers, you will begin to learn to spot problems and have those things fixed before the purchase.
Also, EVERY camper.... regardless of make, model, brand, year, new, used, or anything .... every camper requires due-diligence maintenance and upkeep. It's a life-long process, and nothing can ever be ignored or just assumed. Campers, RV, MH are not plug-and-play systems, plug it in and forget it! They do require constant attention and work, otherwise, even the absolute very best ones out there (you know those 300 million dollar buses that musicians travel in) become junk within a short while. RV's are not plug-and-play, they are a life commitment "hobby" that demands attention. If you are ready for this kind of commitment, then any brand you buy will be a good brand.