I don't drive and when it's not in my budget I stay at the DTD hotels. Transportation has always been fine because I only use these buses coming and going to the parks...once I'm in the parks it's all Disney transportation. I don't have little ones so I don't return to the hotel mid afternoon for a nap. That said, sometimes with all the resort fees and airport transportation it actually turns out to be cheaper staying onsite!
But I understand not wanting to drive. Don't let it hinder your vacation..accept the limitations and have a great time!