I have heard some say they love it bc it is guaranteed payments every month while others cite destruction of property by such tenants.

In today's uncertain economy, getting a guaranteed 8.49% savings vs. a maybe, possibly, would-would've-ever-thought-that-could-happen is a no-brainer. 

Having almost a guaranteed tenant if you will, one investor helping another.

There is very little difference between renting a section 8 home, in fact the biggest difference is that your checks are guaranteed when you have a S8 tenant. the downsides to S8 are highly overrated and in my experience perpetrated by those with a chip on their shoulder about low income people. 

The 5 local banks I contacted so far have told me they cant help because the LLC owns the property and they would not allow me to add my personal name to it to guarantee a loan.

If you plan on refinancing with a take out/conventional residential loan, an LLC will make that much more difficult and costly.LLCs have worked great for me with commercial assets but subject you to crummy commercial loan terms you'll have to personally guarantee anyway. 

Once the sale goes through, Walgreens then leases the location right back from the investor on a guaranteed 30-year lease.Walgreens handles all of the management and expenses!...

I see no upside for you in this deal, other that they would guarantee rent and maintenance(which they will pawn off to the tenant buyer).

Otherwise, it's almost guaranteed that your dues will go up which could severely harm your cashflow.

Do they have and honor a guarantee?