Heh. I want a pecan tree -- heck I want TWO... but not sure if I have the space either. I would have to go for the northern Illinois/Michigan pecan varieties so they would bear nuts. Also, my understanding is that pecan likes well-drained soil, and in my area, it's all clay.
There is a large Shagbark hickory tree (and several smaller ones) out back behind my property. (It turns out that I probably live in the area's natural native Hickory-Red Oak plant communities. They are tolerant of heavy clay soil.) Of course the squirrels are all over them, forget where they buried them, and I always have several hickory seedlings sprouting in my garden.
After learning that shagbark hicory is good eating, I finally managed to nab a few good nuts ahead of the squirrels and though they have less meat than any pecan I've ever seen, they are indeed quite tasty -- it helps that the nut is very fresh, I'm sure. So, I've picked a spot and am allowing one of the volunteers to grow.
Since the soil condition is iffy for Pecans, I may decide to get a Hican -- a Hickory-Pecan hybrid -- instead. I'm pretty sure they can be pollinated by the hickories around here. Getting any harvestable nuts away from squirrels and chipmunks is another issue altogether.