It's always hot in Orlando. August can be rough, especially with the humidity. Make sure you have the A/C at night and you will be fine. Plenty of areas to keep you cool during the day.
Yes, the Sun Pass is worth it! You can create an account and add money to it before you embark on your trip. Nothing worse than pulling into multiple cash toll lanes pulling a camper or in a RV.