> I've had. Is this normal? I feel completely useless.

This is all by design in my view. You're at an organization that is in maintenance mode, all talent has left and the only folks remain are to keep the lights on. Your one or two year projects are facades to keep the sheep from bailing. Leadership needs to keep new folks coming in and old folks from getting bored but the only real priority is to just keep. the. lights. on. Hence, why you get A+++ reviews for warming a seat and most importantly, answering a pager at 3 AM.