Half Life: Alyx is excellent. It is exactly what you are hoping for - a full fledged continuation of the "Half Life" universe... but in VR. To me, this feels like playing "Half Life 3".

It is extremely polished and makes great use of the VR medium. It is fun (and surprisingly funny) and looks fantastic.

Highly recommended!