I have used full size diesels, half tons, and a mid size suv. For vehicles the fulls size diesels are obviously the worst for poor road/trail conditions. Mid sized SUV obviously fills up with gear the fastest, but will probably do best on poor road conditions.
I have used campers, enclosed trailer, large base camp tents (cabelas/wall tent), back packing tents (tipi and free standing) roof top tent, slept in back of SUV and slept in bed of truck with camper shell.
All of my hunts are out of state and typically 7-14 days in length. So if you are a weekend warrior what works for me might not be necessary for you. The biggest issue I have ran into is room for coolers + gear on elk hunts with multiple hunters, coolers take up a ton of space!
Camper/enclosed trailer make for the best camp set up. You get better sleep and can eat better (premade meals in microwave). This is important on long hunts. Obviously limited to where you can pull these.
Second best - sleeping in vehicle or roof top tent. This is great if you plan to bounce around to different areas every day. Only downside is having to load/unload gear every day.