I know of some people that overindolge yet they're still fully functional, working and all.
The first time I tried was when I was around 20. One joint. After that time I hardly touched weed at all. There were some occasions I was offered and accepted, and many other occasions I declined.
I started using the official oil from cannabis clinics when it became legal here in Thailand and to my surprise it helped me with sleeping problems. During the peak of COVID I didn't want to go to the clinic which is located inside a very big government hospital, and also they didn't always have stock of oil, so I got some weed from a friend and have been smoking since then. I must admit that using the clinic's oil, although help with sleeping, didn't have any buzz at all. Smoking (or vaping) gives a good buzz which I can control by smoking more, or less, and also helps with sleeping issues. I only smoke in the evenings when I watch TV and relax before going to bed.
For a while I used to grow my own, but now I find it easier to buy. I use about 10g\month. I always buy 30-40g of different varieties so I switch between them all the time.
No bed effects, especially after I learnt the when and how much to smoke.