We know that low CRI, monochromatic and blacklight make the objects looks different than lighted up by the sunlight or incandescent.
What kind of lamp make objects looks "weird" aside blacklight?

Most LED lighting, even the ones with high CRI numbers. It makes objects appear in the shade of color that the light source is, instead of it's original color

High-Pressure Sodium lighting. I do like the color but you'll find out if you try to use it indoors why it's not generally used for indoor lighting...

High-Pressure Sodium lighting. I do like the color but you'll find out if you try to use it indoors why it's not generally used for indoor lighting...

I seen they used as main lighting indoors, In a book store, it actually looks strange but not that bad.

Low pressure sodium lighting is also pretty interesting when used indoors. Same with clear mercury lamps if you can find them.

Most LED lighting, even the ones with high CRI numbers. It makes objects appear in the shade of color that the light source is, instead of it's original color

My Osram/Ledvance LED Base Classic A 60 7W 2700K color LED filament lamp, don't do this.

Some materials that glow under blacklight, also brights under green light. I wonder if LPS make some materials to fluoresce.

A red light will make blue or green items look black-ish.
Red, white, & light colored items light up nicely (sorta like the effect 'fluorescent-colored' things do with blacklight.)

Some materials that glow under blacklight, also brights under green light. I wonder if LPS make some materials to fluoresce.

SOX/LPS will make anything yellow (or white or orange) show brightly but overall it makes everything look "dead" - shades of brown & black. .lol.

I mean that if that SOX waveleght make some material glow in other waveleght different from the SOX one.

Colored light doesn't make things look weird. You realize that the light is colored so expect to see everythig accordingly. With LED the weird part is that the light itself looks White (or close to that) and supposedly with good CRI, yet the things under it appear not like under any other White light..

Fluorescence (with light emitted of different wavelength from the incident light) in a nutshell is when a material catches a photon of some energy level and an electron in it moves to a high state, then drops back in 2 steps - That could be by going to an intermediate state and then to the original state (so 2 photons that together make the same energy), or in materials that have energy bands and traps like semiconductors (and many phosphors etc do behave like semiconductors in that sense), by wasting some energy as heat while in the higher band before reaching the bottom of the band, and then jumping back over the gap with only the remaining energy

It so happens, that the energy that must be "wasted" before the jump is usually high enough so there are not many materials that would be excited by anything "below" Blue light and still emit in the visible spectrum

I have some HPS grow lamps in my collection.Those are used indoors.

I find that incandescent, fluorescent (especially triphosphor) and ceramic MH have a "glassy" appearance (=desirable, sparkly, beautiful to look at objects under them) whereas most LED have a "plastic" appearance and renders colours in weird ways (similar to what Ash mentions).

I should mention, however, that some LED installations don't do this. I noticed it is mainly 3500K-ish linear integrated LEDs designed to be "beautiful" as well as functional.

Now, all this is subjective, however. A windowless room lit with warm white ~50 CRI halophosphate fluorescent could be "improved" with the "plastic" appearance of LED I mentioned.