Should I? so confused and overwhelmed.

All trailers except a couple are built pretty much the same using the same appliances etc. Light weight or those billed as light weight trailers are light for a reason. The builders skimped on stuff. Do you need or want a bunk house? For weekends kids can sleep on a couch or sofa. For longer then you will want permanent beds. Adults will probably want a permanent bed also. Finding a bunk house with beds sufficiently apart to allow for cuddle time kind of means your going to want a laeger trailer. Keeping within what your SUV can tow is not going to happen if you consider the rest. So realistically if you can swing it and it will still fit your life style get a crew cab truck. A properly equipped 2500 series could easily tow a 30 foot TT or a 30 foot fifth wheel. If you want bigger, then a bigger truck could be in order. Regardless of what you decide, buy used as a first timer. Dont over think quality. All trailers now days have problems. Disregard the fluff and look for fit and and finish. That will tell you a lot.
As for towing? Fifth wheels will travel better, TTs are cheaper, but you will need substantial hitch equipment to tow as well as a fiver.