hello

I'm looking for some kind of spotlight or similar lighting like that for screenshot lighting, maybe like the one they use in real photography
most of the lightings I tried didn't give the lighting result that I want and it still kinda dark

Hmmmm...as far as I know lighting in game is standard. You can edit brightness/dimness and color but all lights have the same standard settings, as in you're not going to download a spotlight and get actual spotlight lighting. Some lights vary in the size of their pool of light depending on how big the light/bulb is intended to be but not in terms of "brightness" past the standard brightness. Anything else, as far as I've seen, is edited into a screenshot of the game using another program.

You're not looking for an actual spotlight?

If you look in buydebug you can find wall and ceiling lights; a lot of people (me included) use those for screenshots.
I made an edit that recategorizes them into Misc Lighting for easier use: https://sweetdevil-sims.tumblr.com/...ng-things-and-i

I also use this screenshot backdrop by Murano, which works as a lamp: http://www.thesimsresource.com/downloads/1117862

If you're looking for spotlight objects, this set by Kewai-Dou might be of help: http://kewai-dou.com/photostudio-set-sims3-object/