>>4284223Give up on the compact part of your plan.
You should be able to find a manfrotto 190 secondhand that will do the job.
Ideally you want something with fat carbon tubes and a large diameter ballhead, but they aren't cheap.
Even with a solid tripod, you need to ensure you're shooting mirror lockup on these as well or you will certainly get a double image shooting city lights.