Water-popping will definitely give you a darker stain, since it opens up the grain of the wood and lets it accept more of the stain. It will also help make the stain more consistent.
I don't know whether you'll get that consistency if you stop at 100 grit, though. We use a buffer to do the final sanding, using 120 to 150 grit screens. (Screens are black carbon discs) The buffer covers every bit of the floor--both the edger areas and the big machine areas.
Using a buffer is something that was never mentioned in the homeowner articles and books, or in the rental machine brochures. I know--I was self-taught at the beginning, and those books just didn't cut it. In those articles, flooring sanding always stopped at 100 grit on both machines, and then a natural sealer. You can get away with not buffing if it's just a sealer. As you found out, a stain is not so forgiving. It shows every machine mark and all the uneven sanding.
It's harder to use a buffer without some practice. I briefly looked at Youtube, and the videos titled "Using a buffer" are mainly about using one for polishing, waxing, and so on. You might learn technique from those videos, but I'd look for a video on doing floors that specifically talks about using the buffer for screening a hardwood floor.
For a stain, we use 120 paper on the edger, and 100 or 120 paper on the big machine. We scrape all the end walls out about a foot--that gets rid of any marks that the edger leaves. Then we use an orbital sander with 150 grit paper, or hand-sand all the end walls with 120. After that, we apply water evenly with a wrung-out rag, and let it dry for a few hours.
You can walk on the water-treated floor, but you need to be careful of scuffing it with your toes while you're applying the stain, or wiping it off. The scuffs will show.
If you don't care to use a buffer, you have other options. I've not used them, but the square-buff machines at the rental places may be useful for getting an even sanding, with 120 or 150. They're easy to use.
Quote:
and then used an orbital sander up through 100 grit.
Was this a small, hand-held orbital, or some type of stand-up rental machine? If it was a stand-up machine, going to a finer grit and using water treatment should make the floor appearance more even. If you don't want to scrape end walls, you can spend more time sanding out edger marks with a 100 grit paper on the orbital. Then hand-sand them with 120--it doesn't have to be heavy sanding, but enough to take out the small squiggles that 100 grit paper leaves.
The main thing here is that you want consistency. Some combination of more even sanding and water application will help you get that. What I'm describing above is the pooled experience of three different floor companies, and we're always trying new techniques. But this is tried-and-true stuff.