beware the person who warns against it - they have an agenda. it's unquestionably good for you when done properly and within your limits of capability.
i've heard less of the "but i don't want to get huge and bulky like a bodybuilder" these days, probably because as resistance training increases in popularity, people are realizing how incredibly, ridiculously, ludicrously, unreasonably difficult it is to build and maintain muscle.
For a typical person without special circumstances deadlifting with proper posture is the most important exercise you need to be doing, IMO. Personally, I was amazed that my minor back aches were gone, my shoulders stayed back without effort, and I was more confident in my posture. Why didn't someone tell me to deadlift sooner in life?