Only when flown at MTOW, 300KIAS and 500 ft in mid-day summer turbulence, followed by a harsh pull-up! Flown gently and smoothly at a lower weight, then no, they're not!
Nothing intrinsically dangerous or hazardous about a low fly-by if the pilot knows what he's doing. Sadly, many simply don't!