Anyone know what I can expect from juniper wood for use in
woodworking?

I've used juniper to make decoy bodies. It's excellent for that.