This varies tremendously with each situation and can be influenced by the owner, the condition of the pet and the reason for euthanasia.  In the end, being present during euthanasia is completely up to the owner.  Before making a decision, consult with your veterinarian on what to expect and if it's the right decision for you.