Well, the WGS 95 version of it is special because it's the one system that ran A/UX and Appleshare Pro, but, yes, if you're *not* doing that it's just a Mac in a particularly monumentally-scaled case.You can do that on pretty much any machine. There's nothing special about the 950 in particular when it comes to serving, except that in the early '90s when it was current, it held more internal disks than any other Mac.
I've never dealt with a Quadra 800 (I had a Q650 instead) but I did years ago spend some time bringing a dysfunctional Power Mac 8500 back from the dead, and it uses the same case. And, well, everything terrible people say about that case is true. The laminated "plastic shell with aluminum shielding" construction makes it a bloodthirsty monster just waiting to take a chunk off your fingers as you fight with trying to get the *#$*ing top on and off. I especially had issues with the little tabs along the bottom of the case; they just begged to snag on things, including the lid as you tried to get it on and off, and I ended up having to cut some particularly bent ones off because of what a hassle they were causing. (It didn't help that the machine I was working with had obviously been dealt with by a less than careful hand in the past; the lid was sitting drooped loosely over it when I pulled it off the junk pile because of the mess they made when they pulled it apart.)
There's very little metal in the case other than that shielding, and I have no doubt whatsoever that shipping one now, knowing how well plastic from that era ages, is just *asking* for trouble. I second the recommendation of a Quadra 650 instead. It is literally *exactly* the same motherboard (there's actually a pin on, what is it, the speaker connector?, that tells the motherboard what case it's in for identification, so if you swap a motherboard from one to the other the ID will change according to which chassis it's living in) and while the case isn't "exciting", being very much like what you'd find on a PC clone from a company like Dell of the same era, all the important parts are *metal*, it's reasonably sturdy, and far less gimmicky.