When I first tried to digitally photo-scan my negatives I also started with a tripod setup and it was a pain. I now solved it with a setup I built myself out of a piece of wood, a quick load plate and ... Legos. I use a Nikkor macro lens which does not have inner focusing. To get the negative in focus I set the lens to infinity and place the Lego-rig right in front of it so that the negative plane and sensor plane are aligned. Then - while focusing - the lens pushes the Lego-rig ahead and this keeps the negative and sensor plane aligned. I built the Lego setup so that once I can see the grain I do have the full negative in the frame. The negative carrier is built out of two pieces of cardboard with a window in it I can open it a bit or squeeze the neg between the two pieces of cardboard which flattens the negative.
It all sounds more complicated than it really is. But with this setup I have the negative easily aligned and I am able to scan a roll of 36 exposures in less than 5 minutes. Setup time is less than a minute.
With this setup and a 24MP camera, what I get is photo-scanned images of around 20MP. I could change the setup slightly to get a bit more, but that would slow down the scanning and the 20MP are enough for my purposes anyway.