Certainly if you use a big enough gun.
With a pistol or normal gun, probably nothing will happen.
With an anti material rifle you might get some luck if you are close enough.
Or you just take a tank cannon or artillery, those should have plenty of muzzle blast.
Obviously hl:alyx. It’s one of the best VR titles, and trough steam workshop mods you can get maps almost as good as some other full games.
I expect you to die 1&2: great secret agent puzzle games
Into the Radius: it’s a bit like stalker in VR, the gunplay is quite unique, as you will have to maintain your weapons to keep them operating properly. Also: magazines are expensive, so try not to drop any even in the heat of battle.
Hotdogs horseshoes and hand grenades (h3vr): a sandboxy game about shooting with many extremely well made guns.
Also Super Hot is quite fun in vr