I prefer night lights in amber, which is why I think it's a shame we moved away from neon. I use amber where I can in my home, but also have discovered the snap-on switch plate night lights, and I really like those. The color temperature is on the cooler side, but they have a dimmer/off switch if they are too bright for guests.
We got a bunch of these to use at the lake house when we renovated last year
These switch plate night lights are a little cool (5000K) for a night light. I installed one in the kitchen, in the hall near the bathroom door, and in the guest bedroom. I don’t think my version has an on/off switch.
I tried a blue LED night light in my bedroom labeled “soft blue” and it was relaxing while going to bed, but disturbed me while actually falling asleep. It’s true that blue light will cause sleep disruptions, at least for me.
I have a small stash of 4 watt Rite Aid brand C7 night light bulbs. They produce the most pleasant and warm light at night for me. Even “soft white” LED night lights seem to white with some blue wavelengths mixed in.