I think I've only really seen this as a Honda Element - otherwise I'm not sure it meaningfully exists. The reality with most AWD cars is that their important guts are hanging lower compared to 4WD trucks even when the paper ground clearance is similar.
My previous car was AWD and I have a 4WD SUV now largely for off road performance, and there's no question 4WD (particularly 4LO) is much better at getting unstuck in trail conditions. The AWD is definitely superior for icy pavement in the cold months though.
> Bonus points if you don't care about wrecking it
This was actually what mainly pushed me over to the 4WD side instead of something like the Forester. The crossovers can actually get you to a lot of places but they do get thrashed if you do it enough. They are still more geared for pavement use but, if you're wrecking your suspension off road, the on road performance isn't gonna be great either.