Small scale lighting is always on my mind too so I get it . Whether it's for seedlings, that one plant that wants a little bit more than the window offers, or the one plant that needs to go on timeout for pests, I always need just a liiittle bit of light where I don't have it.
I'd suggest looking at these unless they're what you're already talking about.
$5.67 at my walmart and the clamp is nice but can be removed if you don't need it. The aluminum reflector can be removed as well so it's just an E26/27 socket to a 2 prong plug. They're what I use and are pretty handy.
Edit: forgot to mention, Amazon has PAR38 LED floodlights from a bunch of manufacturers for $5.00/bulb. May want to look into some of those.