Yes, I have a mod to increase the chances of the move in scenario. I think they're fun. My favourite is the Ancient burial ground ... it virtually gives you instant haunted house and a bunch of collectible gemstones.
To get rid of rodents, you simply click on the trash piles and choose the available options, which are either "clean up" or "shoo rats"
Usually in the trash laden house scenario, you also can pick up a bunch of random vegetables lying around, like tomatoes etc, and I believe a maid will also arrive and help you clean up if you choose to let them help.
The Burial Ground has a Ghostbuster ( he looks like the repo man and you don't need ambitions for him to show up ) arrive and ask if you need help busting your ghosts and the Leak scenario spawns a handyman to offer to help fix your leaks.
The meteor scenario has the local fireman show up and offer to help you clean up and the bug ridden house scenario has a scientist show up and ask if they can collect some of your bug samples.