agape

mcgonagall mcgonagall is probably the professor suggested to be closest to snape, with their quidditch rivalry bordering a frenemy-style relationship - but she seems very old-school tough love/dismissal, the type to snap "just have a whisky/potion and get on with it"

dumbledore dumbledore might offer some kind words, but their relationship is... complicated. snape is, obviously, a brooding little bitch - he's not about to forget that dumbledore dismissed his wanting to die like it was nothing when lily died, so he's hardly going to think that dumbledore's sympathy is genuine

madam pomfrey i think madam pomfrey would be similarly no-nonsense to mcgonagall; she sees worse every day from kids' magic going wrong, the yearly disaster whenever harry is there, and quidditch injuries, and even when harry is injured i don't remember her being particularly comforting - she'd hardly have time for snape's theatrics.

hagrid weirdly, i think hagrid would be sympathetic - he always seems fairly nice about snape, probably because anyone dumbledore trusts is 1000% incredible in hagrid's book - but i doubt snape comes across hagrid that often outside of mealtimes (should they sit together) since hagrid lives outside the castle, unlike the rest of the staff (which seems a bit mean, on reflection - though maybe hagrid likes it because he prefers nature and his own space, and the freedom to do illegal activities like dragon rearing and breeding possibly illegal creatures, but i digress)

the others i doubt the other professors are close enough to snape to offer anything more than polite, surface-level sympathy for a coworker - and snape knows that.

if we want to get into little bit sad territory, imagine snape in the staffroom. there's a bug going around; everyone has had it at some stage. he leaves a tray of vials filled with pepperup/some other potion; people take them gratefully.

then he overhears sprout like "here filius, make a tea out of this and you'll be right as rain!", mcgonagall sharing her own whisky for a hot toddy with madame hooch when she gets a chesty cough, or the staff put together care packages to take down to hagrid's hut when he's ill.

snape isn't offered anything. the potions quickly run out.

he heads to the hospital wing to ask for another, because his brain fog and aching limbs and sinus pain mean he's firmly not in the mood to be bent over a cauldron to be making any more - and besides, he's made all of the potions for the hospital wing anyway - they're basically his to take. he made them especially for this bug going around. he's handed them out in the staffroom already. he's left them in the slytherin common room. he even took one to dumbledore's office.

but rather than offering anything, madam pomfrey shoos him away quickly, tells him to stop being such a bother - so he just traipses back to his own room, fully aware that nobody will gather leaves for a curative tea for him, he'll be receiving no care packages, no hot toddies, not even his own potions - and if he doesn't show at dinner, because he's tired and grumpy and aching and just wants to sleep, nobody will ask after him - because nobody cares