In Chicago Equinox used to have a good bundle for visitors. Not cheap, but gives the opportunity to use their gyms.
Yes you pay by the month for a membership, they also have free trials for first-timers and daily passes after that. Unsure if a weekly pass exists.
Thanks! Your answer is awaiting moderation.