You have to go quite heavy and do it very frequently to actually look bulky, or even visibly muscular, when fully dressed.
The effects of moderate weight lifting - defined loosely by me as squatting at most your body weight on a barbell - are barely visible. But you will feel much better on a day-to-day basis and all your health numbers will improve massively.
Most people are not like this. They can lift weights and benefit from a stronger body without looking any different.