SNL is a sketch comedy show where Simpsons has a consistent cast. The characters used to be real and relatable but now have more in common with an SNL type sketch comedy show with no expressed identities.
Yea, the stories and characters depend on the writing and writers change over time. No one looks back to Conan O’Brian leaving as the end, Groening et al just hired a replacement.
The quality of the show still depends the writing. Plus, animated characters can take on every imaginable role (as Homer’s multitude of jobs show).