Seriously, the city is so big and detailed that I feel like Cyberpunk 2077 only scratched the surface of it. Night City is the heart of Cyberpunk and moving to a whole new location would be a huge bummer to me.
Ideally it would take place maybe 10 years after 2077 and maybe another bomb went off or something and turned a big chunk of downtown into a wasteland and now Pacifica/Dogtown is the new hot area.
Supplement this by making part of the story take place on the moon and/or the Crystal Palace and allowing you to travel back and forth like in Witcher 3 and I think that will feel plenty fresh for a whole new game + a couple of expansions.
Yeah, I know what it's based on, and I think you're probably right that most of the setting in the original tabletop game takes place in Night City, but I don't know if that means that CDPR will follow that lead or not you know? Obviously I hope they do but currently no one outside of that company has any idea what the plan is as far as I know so all I can do is hope.
I'd be very disappointed if they don't. But I have faith that they will stay close to the source and remain in Night City for at least the main storyline.
Honestly I kind of hope there will be DLCs with completely different characters and smaller stories to play, though I kinda doubt that'll happen. Would be interesting though.