As we spread into the cosmos we too will find that the further we go it's just too much fucking effort for too little benefit.
Our own orbit? Absolutely, extremely useful, been doing it for 50 years, will keep doing it.
The moon? Totally, useful for science stuff, maybe some resources, plus easy commute.
NEOs? Yup, we'll grab a few of those, if only to prove we can.
Inner planets? Mars is probably worth a go, and there's some weird possibilities that even make Venus plausible.
Asteroid belt? Nah. Unless we find something real funky on Ceres or something.
Outer planets? This is a stretch. Maybe a Jovian moon or two is worth a look, but man, it starts getting HARD at this point.
Kuiper Belt? Oort Cloud? Lol, no, why would we. It's all useless junk that is VERY far away. If I told you there was a free Pontiac Fiero waiting for you at the South Pole, how eager would you be to go get it?
At the point where this sort of Solar System level expansion is plausible it's much more likely that we look inwards rather than continuing to struggle outwards. There's nothing for us out there. It's hard, and there's little to no reward.