They are trying to make Alyx work standalone: digitalfoundry.net/…/valve-looking-into-a-steam-f…

But that will probably be an exception due to the amount of resources Valve will invest into getting it to work well, you’re right that few other games on that level would run standalone.