Few weeks? You do realize astronauts spend a year in the ISS in some cases with zero gravity? Why would we only be able to stay for 2 weeks? You get muscle atrophy but at a slower pace than the ISS - which can also be offset with exercise.
We can also probably generate artificial gravity eventually so that’s not even the biggest challenge compared to the others I outlined.
Not sure about Venus, don’t know much about it. I thought it was much hotter though? Last time a probe was sent it melted in seconds … why would we want to subject ourselves to these temperatures when mars temps are much more favorable?