https://www.enginebuildermag.com/2021/05/two-cylinder-v-twin-chevy-engine/ Write up on one in the race bike.
It might shake less than you'd think. The theory is actually quite interesting. Balancing a single is a problem. No counterweighting, and it'll shake up and down. Full counterweighting, it'll shake side to side because, though the mass of the piston and rod is counterbalanced, there is nothing counterbalancing the counterweight halfway up and down the stroke. Any intermediate amount of counterweighting, and it'll shake up and down some and side to side some, and it's a judgment call as to more of which you can live with. Add another cylinder at right angles, and the second piston and rod will counterbalance full counterweighting at mid-stroke. Of course, on the SBC one bank of cylinders is ahead of the other, and the rods are side by side on the crankpins, unlike the fork-and-blade or master-and-slave big-end arrangements used e.g. on Harley Davidsons, aircraft radials, etc. to get the cylinders in the same plane. So on a SBC-based V-twin there will be a small amount of rotational vibration about the vertical axis. It might be possible to do something about that by making the counterweights slightly asymmetrical.
If you want an idea of what it might sound like ... fire up your SBC then start pulling plug wires until the back two are the only ones left I'd offer to do it but I already receive regular doses of court imposed, medically applied shock treatment on a regular basis. Any more and my main fuse may trip
An inline 4 lives better, than a V4, when you start making power. The crank loads are spread across more bearings.
I had to take the pass side wires of of my poly motor to do something and forgot. Fired up kinda hard but ran ok but wasn't right. Then I remembered, whoops!
There was a V2 KB hemi that ran at Bonneville in the 80's or 90's powering a MC streamliner. It was made from junk Top Fuel parts. Made power and ran hard, but shook itself silly. Lots of SBC V4's were made for sprint cars in the late 60's, very successfully.