@Flow83, I wouldn't be able to answer the question 'what gets you really excited', but don't see it as a problem to be solved. I'm suspicious when I hear someone say something will fullfill them or satisfy them till they die, sounds very much like a marriage vow and about as meaningful to me. Hedonic adaptation is inescapable imo, the most you can say is 'this can satisfy me for a while'.
Actually I think of it as a "right NOW" question. I am not a fan of the idea that you decide or there is one correct "life purpose" that once you find it life is all smiles. That's a big one thrown out there in self help.
My personal experience is that the more I ask it, the more refined it gets although it had stayed in the same field and in the same general direction.
The inner work has helped to distinguish what a deeper desire is for ME and what I truly want to do bigger picture, which gives clarity of what I choose to do with time. There are always multiple desires in us and left on autopilot it is scattered.
Even my best experiences with sex and most badass "accomplishment" stories in that arena are tiny, TINY compared to the feeling of getting the call to work directly with someone who I idolized and was inspired by when I was younger. The realization of stuff that fit more into the 'dream' category.. especially when I didn't previously think I'd ever really be good enough.
Of course, still a balance act. You can get obsessed with work/goals or whatever and have no fun.
I would describe it as a general sense of contentment vs a general sense of 'something not quite right' that is constantly trying to be fulfilled.
If you are able to ENJOY whatever you are doing, even there is absolutely no rhyme reason or structure to it, even if it's something that society would tell you is 100% selfish blah blah, if it resonates with you and comes from a genuine place of self expression to me that's all that matters