Yes it is at will, but it is true that you won’t probably be going back to the company in your life as you said unless you become something.
Think about this way, you got hired and worked for a week. After the first weekend, you tried to badge in, and the door is still locked. you finally realized that you are fired. Do you want to re-apply to the company like that?
Google has write something(not detail) like that the employee’s leave is regrettable or not. If it is not regrettable, you will not have any chance to have an interview with them. I believe other companies have some mark like that.
I hope you to think carefully and make the right decision