Most of your old-school "piano lamps" stand on the floor and were designed to be positioned at the side and a little behind the person playing the instrument. Usually they are oil-fired with burners of the centre-draft Argand or Kosmos varieties, though I have seen Duplexes and maybe a B & H Rayo. Many of them were scrapped for brass in WWII, but there are still some out there, even with electric bulbs replacing the old oil burner.
There are plenty of nice lamps available after the turn of the 20th century that sit on top of the piano...the standard "Emeralite" banker's lamp--brass with a green glass shade--is very nice for an upright piano as it illuminates the music stand & the keyboard. I'm currently using one right now for study at the writing-desk. (The 1935 Eagle is retired to a side stand so I can use it nights when a stronger light is not needed.)
My latest lamp purchase was a c.1910 B&H Rayo center-draft. It needs a new flame spreader, chimney, wick, shade, and fuel tank cap. Other than that it is ready to burn again--especially since there is a fuel cap and a flame spreader sitting in my parts start from a severely beat-up Rayo.
Kerosene lamps are weird, can be smelly, take time to warm up, and definitely are fire hazards if not tended well. But they are a nice solution for some of us light-sensitive types because they do have a warmer look, they do give off white light, and they look very pretty on display. But they are dangerous if filled with incorrect fuel (An antique centre draft lamp is kerosene only, not lamp oil or gasoline!) and they can be more expensive to run.
_________________
Your neurodiverse (Aspie) score: 134 of 200
Your neurotypical (non-autistic) score: 72 of 200
You are very likely neurodiverse (Aspie)