I am skeptical that a lot stuffed with "tiny houses" is actually more resource-efficient than that same lot with apartment buildings.

And, uh, the only resource that "big properties" exhausts is density. If you don't mind having to drive half an hour to get to town, there's plenty of room.