There is no such thing as “The Mclean Stevenson Effect”. The truth is he wasn’t a very good actor. So, his show didn’t do well. Every great actor has made his share of bad decisions. IIRC, The Mclean Stevenson Show had roughly the same premise as Frasier. But Kelsey Grammer can act.
Dropped by show, dropped by his own little gun.