Yep, CptjohnC is on the right track. Any bike can get you back and forth. Its how you go back and forth and how much you carry that should guide your decision.

Do you want something sportier or able to haul stuff? Do you want a comfy, soft ride, or responsive and efficient? This is going to be a very personal decision based on what you like. Take some test rides on some very different style bikes. Don't just assume you want lighter until you ride some light bikes and see if you can really tell a difference.