I decided to do a test on some scrap pine and what I stated above turned out to be accurate. I applied 3 coats of both kinds of polyurethane.
Oil-based polyurethanes leave an amber glow and require fewer coats. But the five-hour wait between coats and 12-hour wait after the last coat will put a bedroom out of commission for a few days—and you'll have to put up with a strong odor.
Both water based and oil based poly offer good protection; the biggest difference is in appearance. If you love the natural look of maple, apply a water-based (waterborne) polyurethane. They appear milky in the can, but go on clear and remain clear. They'll slightly accent the character of your wood without giving it the amber tint of an oil-based poly. (However, some woods, like the oak shown, cry out for that amber tint.) Water-based finishes dry fast—most within two hours—so you can apply several coats in a day and use the room that night. They have minimal odor and clean up with water too.
But water-based polys have their tradeoffs. They cost twice as much as oil-based polys. They won't give wood the rich glow that oil-based polys impart; some even consider them cold looking. When I applied waterborne poly recently, I found that it went on so clear I had to use a bottle cap to mark each 8-in. wide swath of finish as I went.
Most water-based polys contain only 30 to 35 percent solids, compared with the 45 to 50 percent solids in oil-based products. Since these solids create the protective finish, you need to apply four coats, as opposed to two or three. And you may need to apply additional coats every two years or so.