Hackberry can have a great spreading profile if planted with enough space around them, and in most communities, no one else will have them, or know what they are!
I once lived with a pecan that spread across THREE yards and was even reaching pretty well into a fourth! Plus, you get to make PIES!
Live oaks stay green all winter long! They produce a much sought after lumbar too!
Mimosa have a great bonsai-like profile, and the hummingbirds LOVE the blossoms...
American holly will give you privacy all year long, and you can carve sculpture out of the easily whittled white (virtually grain-less), wood if it dies in a storm or you have to cut it down.
Yew trees look like natural bonsai (especially if encouraged), and you can make hunting bows out of the branches.
Osage orange will repel roaches they say, and are quite unique...
Some chestnut trees are extremely rare, and smell like human semen when in blossom. Because the wafting odor can be detected up to a block away, clueless neighboring couples will fight, thinking their spouses are cheating on them while they are away at work...