It’s been so long since I’ve worked on anything cool 😭

Anything you can do to make the boring work cool?
E.g. taiming legacy, researching new design patterns, new techniques, better IDEs, become a power user (keyboard shortcuts etc), improve your development+deployment pipelines, automated refactoring tools, etc

What do you work on atm (if you can say)?
Is it that your too divorced from the user that you feel like you're work is meaningless, or is it that the tasks themselves are monotonous?
If the former: try sprint demos before each retro with the product owners or Dev team.
If latter: can you automate the monotony?
What about open sourcing your work - working with others can be very rewarding.

^ hope this helps ☺️

Cool tickets are put into the backlog to rot

That's what side/hobby/pet projects are for

At least you get a good pension?

A year here.