Hi Katie,
Don't take the notes of tragedy too much on-board :)
If you're from Ireland and are planning a career there then the economy is really a problem; if you're looking for 'transient' work and are okay with waitressing or barwork (which pays okay and is an instant access to a great social life) then it's not as much of a problem for you.
It is a crazily expensive city, this is true. It's also a great one.
It's pretty compact; so you can get anywhere you need on foot or bike, so the appalling public transport isn't so much of an issue. As long as you rent somewhere fairly central which, in the current market, you'll be able to do.
There's a lot to do and see and it needn't always be that expensive. The city has, over the last decade or two, started to promote an expansive arts scene so festivals, free outdoor cinema, galleries, theatre and so on are often free (especially during the summer). During the winter, well, it's going to get wet and cold but just cosy up to a pint and buy an umbrella :)
Do buy a guide book and get an idea of the layout of the city and if you have any questions about areas or anything, feel free to pm me.
Regards,
Eoin