Aww, It's so annoying when a villager moves into a bad spot, especially if you used to think the spot was good, but then lately realized you wanna put a PWP down there or something x3 The reset trick is really simple, all you have to do is get the game to think it's a new day (TTing 2 days straight from the day you got the villager to want to move there works the best) and instead of going in with your mayor just create a new character, search the area, press home if you don't like it and try again. If you do like the spot just go ahead and finish up your house stuff and once you can , save. It's really simple, just be sure not to get on an existing character when the day resets since logging in with an existing character saves the game.
You probably know all of this but eh.