There aren't a lot of them these days. Hitman probably the only one still going strong.
I would recommend Streets of Rogue from the indie sphere. It doesn't have vents you can crawl through but you can poison the ventilation system, bribe the police, hack security robots, hire people as bodyguard or to cause a ruckus. Surprisng amount of options for a top down roguelike.