When does a person have automatic standing and a reasonable expectation of privacy in a 4th Amendment violation claim?

Hypo 1: Bob sells crack. He weighs and bags crack inside his house. Cop is suspicious about Bob, so he sneaks up to Bob's house and watches him through a small hole in his window curtain. Cop watches Bob sorting and bagging crack cocaine while reading a book that says, "How to Maximize Profits as a Crack Dealer." Result: Bob has automatic standing to contest Cop's illegal search as a violation of their reasonable expectation of privacy because even though Bob was indeed doing something super illegal in his home, the Cop should have first obtained a warrant before looking through a small hole in the curtain. Note that had Bob been working in front of an open window visible from the public sidewalk, then there would be no expectation of privacy. But since Bob had his curtain closed, the fact that a small hole made his actions visible from Cop pushing his face against the window doesn't mean Bob didn't have an expectation of privacy.

Hypo 2: Same facts as Hypo 1, except Bob is bagging crack inside of his grandma's house, where Bob lives. Result: Same result as Hypo 1. Bob has automatic standing because he lives in the house.

Hypo 3: Same facts as Hypo 1, except Bob is bagging crack inside of his drug dealing partner's house, Sam. After a few hours watching Bob put bags of crack into his pockets, Bob walks out the front door and is immediately arrested. Cop searches Bob and finds the crack, then searches the house. Result: Bob was at Sam's house. Bob neither lives there, nor was he an overnight guest. Thus, Bob has no automatic standing, nor does he have a reasonable expectation of privacy in what he did while in Sam's house.