We do this all the time...yes, you can come close to the look of ambered floor finishing film. There are some one step floor sealers coming on the market that will color the wood to give it that yellowish look...they are primarilly professional use products. You must follow stain application rates and dry times. Use a finishing system that is designed for product compatability.

The PO probably repainted over a dirty, glossy surface. The hard part about painting is the prep. That's why so many DIY'ers skip over it. Painting over oil base with acrylic latex is done every day. It's the practical thing to do. The only requirement is a clean, dull, sound surface. You're going to need to invest in some sandpaper and you're going to need to burn some calories. On the cabinets, peel away or sand away as much paint as you can. Sand the finish to dull. Use a #180 grit aluminum oxide paper or sponge. Feather sand any paint ridges to smooth. You can spackle over dents, dings, ugly spots, etc. prior to priming. Sand the spackle smooth and wipe with damp cloth. Wash the surface with ammonia and warm water. DO NOT USE TSP. Rinse well and dry it. Prime with Zinsser Bulls Eye 1 2 3. Let it dry Repaint with a 100% Acrylic Latex enamel. The other trim may need the same attention if it's peeling. You do not need to strip to bare wood. Simply sand the trim to dull, clean it, patch holes, prime it and paint it. Consider it all enjoyable exercise. Michael

This is an old post so I imagine this has long since been resolved for the OP, but since I just saw it, figured I'd throw our experience in anyway for future searchers on this topic: We have an interesting case study in that the floors in our house and our neighbors' identical house were both redone about five years ago (before we were on the scene, so don't know specific products used). The floors are identical hundred-year-old white oak installed at the same time (same family built both). Both were sanded down, neither was stained, and ours was finished with a water-based finish, theirs with oil-based. Both still look fine five years out (if you ignore the scratches from our dog!) but the looks are different. As someone noted above, the oil finish is a bit warmer and much shinier. I think it's fair to say it looks newer as a result, though how much of that is the wear-and-tear we put on our house (significantly more than our neighbors!) is hard to say. Our water-based finish is more matte-looking and pulls out more browns and beiges than yellows and reds (if that makes sense). There are apparently some differences in how you can clean and touch up the two finishes as well. (We use Bona hardwood cleaner on ours, which seems to work fine.) Anyway, just food for thought on this!

I would have them redo it anyways. Your floors have a lot of chatter in the sanding. Waves throughout, which needs to be addressed. Bona Mega is a upgrade from Woodline and Traffic is a upgrade from Mega with HD being their top of the line finish. If, these finishes do not outperform Woodline. It is because it was improperly installed/applied. The contractor's drum sander is no good. It needs to be looked at. The drum or motor shaft is no good, causing the chatter. A hard plate system can remove it, but will take a lot of time based on the severity of the chatter.