I wanted to ask, I have seen a lot of posts etc on social media about tahajjud being a vital and very powerful prayer for hajaat but mostly seen this on Sunni pages, I wanted to ask, from a shia perspective is this true or are the benefits of this prayer primarily focussed on something else?

No doubt for sure Salatul Layl has many many benefits and blessings. https://www.al-islam.org/salatul-layl-tahera-kassamali-hasnain-kassamali/hadith-salatul-layl