You will not be a resident of New York. That said, you will still be responsible for sales tax if the delivering company (B&H or Adorama in your example) has a nexus in Connecticut.
If you instead did the same thing with New Hampshire, Delaware, or the other three states without sales tax, then you wouldn't even need to worry about that. You might have to worry about local tax (e.g. in Alaska).
Be careful though. Deliveries in the United States are not always that precise in their delivery dates. There is some risk that the package might arrive before or after your hotel stay. If you can stay the whole week in one of the five states without sales tax, that would be more reliable than trying to time a hotel stay. I would expect New York and Connecticut to have more expensive hotels than the states without sales tax. Alaska being a possible exception.
I would also be a bit concerned with the billing address for the credit card that you are using. Under certain circumstances, that might impact your tax treatment. Or block the transaction entirely if your country is blocked from those products for some reason. You should get informed of this at the time of ordering if it's an issue.
Note that if you pay in New York and then ask for delivery in another state, they will probably have you pay sales tax at the time of purchase. As a general rule, whenever you pay in person, businesses charge you the sales tax at that physical location. The way that this will work successfully is if you buy online.