I think it would be fucking up the tides something awful...or worse. The gravitational pull of Jupiter if it was that close....damn
How would be scary? Are you scared of the moon? It is not like moon just appear suddenly, the idea was if the planets were as close as the moon. It would be just as normal day or night for mankind.