I personally think the western hognose is really no harder to care for than a king or corn, but they are a little more easily stressed and generally need a little more full-body support when being handled, as they don't "hang on" like some other colubrids will. One has to be careful to not confuse care for the western hognose with that of the other species, like the eastern or southern... or even the exotic species, like the Madagascar varieties or the South American ones. Those are all quite different in care needs.
I've never actually had one bite at anything but food, and I think you'd have to try pretty hard to get one to bite you, but anything can happen I suppose. There's a website out there somewhere with a guy who wanted to see the effects and basically let a western hognose chew on him. The real fear with lightly venomous snakes is not the venom itself, it's the possibility of an allergic reaction to it. Everybody's tolerance is different, one person may just get swelling around the bite area, another may have a full anaphylactic reaction. Though, I've never heard of this happening with a hognose, but if it can happen from an ant bite or bee sting, there's no reason why it can't from a hognose too if the conditions are right. Unless you already have a known venom allergy, I wouldn't consider it to be a risk, personally.
I feel they're great little snakes, with a ton of personality and as long as you meet their basic care requirements, can do great as pets. Though, if you're only avoiding a king snake or corn snake because they are constrictors, hognose often employ methods such as body pinning, and then rely on their enlarged rear fangs to hold onto a prey item. It isn't going to be any less "disturbing" to watch for someone who doesn't really like snakes to begin with.
The best place to acquire one will be from a reputable breeder. Someone with a guarantee and will answer your questions.