It affects your _home_. You've lived in a place for 10 years and suddenly you have no privacy because a big block of units gets stood up looking right over you. Or they block your sunlight, build right up to the boundary, or your quiet leafy neighbourhood just isn't quiet anymore and that's after you lived next to a construction site for 6 months. These things can have impacts on people's relationships as well.
Of course the world changes, such is the price of progress, and _usually_ those affected can afford to wipe their tears with big stacks of cash.
But I don't think it's fair to characterise all NIMBYs as just greedy, a lot of people just want to live in the neighbourhood they thought they were buying into.