While I really enjoyed Alyx, it's very much a game built around it's own limitations. It's more of a survival horror game in a way, because of the limits on ammo and deliberately mechanical reloading. There's no melee at all, so once you're out of bullets you're done for.
For all the roughness of Half Life 2 VR Mod, I find myself enjoying it more because it has fewer limitations imposed by the move to VR. It doesn't always work (and the vehicle sections in particular really push it), but as a mod of a 20 year old game, it's really good.