Trees with small leaves or leaflets
Why choose a tree with fine foliage rather than coarse foliage? One reason is to create an optical illusion. You can make a small yard appear longer by using plants and shrubs with large leaves in the foreground and trees with small leaves in the background.
Trees with fine foliage don't make as much of a mess when the leaves drop in autumn. The leaves break down faster and blow away easier. Thus, less raking is required. A few passes with the lawn mower may eliminate the need to rake at all.
Most trees with finer foliage don't create dense shade. Grass and many plants, flowers, and shrubs do better in dappled shade than in dense shade.
I've listed a few native trees below that have small or fine foliage. There are others, but I've limited the list to some that come through most ice/wind events without severe damage.
Of course, there are other factors to consider as well, such as the type of soil and the amount of moisture that will be available to the tree. Links will open an information page about the species at the USDA Plants database.
Amelanchier canadensis -- Canadian serviceberry
Carpinus caroliniana -- American hornbeam
Crataegus -- Hawthorn species
Gymnocladus dioicus -- Kentucky coffeetree
Malus ioensis -- Prairie crabapple
Ptelea trifoliata -- Common hoptree
Quercus palustris -- Pin oak
Viburnum prunifolium -- Blackhaw viburnum
Viburnum rufidulum -- Rusty blackhaw viburnum