There was a time when medicine put a lot of focus on the smell and consistency of bowel movements. There's probably something to it but we have better diagnostics now. That said, normal bowel movements can have a bit of an odor but it should not be strong or particularly foul-smelling. If it is, consider changing your diet or getting it checked out if that doesn't help. I found that just cutting out fast foods made that particular bodily function nearly odorless.
Diabetes was originally diagnosed by having sweet urine.
No, poop is meant to smell repulsive. This is evolution's way to discourage you from doing anything unhealthy like touching it or eating it.
Doctors have better tools than smell and consistency. However you as a layman don't normally have/use those tools.