I drive a Yukon XL, which is the GMC version of the Suburban. So I am no help in recommending a smaller SUV to you, with a 3rd row, from personal experience. However, I do know 2 people who have the Dodge Durango and LOVE it.
There are 2 issues I see with a lot of the smaller SUVs with a 3rd row. First is the 3rd row seat is not a full size seat. Even in my XL, it is not as wide as the middle row seat, while it has 3 seatbelts, it has to be more narrow as it is above the wheel wells. Second issue is the amount of space behind the 3rd row and the back of the car. We first looked the Mercedes SUV, drove like a sportscar but the 3rd row was SO close to the back of the vehicle. If we got rear-ended, I was worried the 3rd row passengers could be severly injured. So while people don't always want the space in the back for cargo, I do like that I have 2 feet of room in the back of my SUV between the 3rd row of seats and the back bumper, when/if someone decides to cram me from behind.