The changes to the constitution of the Republic of Ireland required for Ireland to ratify the Lisbon treaty were approved by Irish voters this weekend, meaning that the last true hold-out for the Lisbon treaty is the Czech Republic (the Polish president has promised to sign on account of the 'yes' vote in the Irish referendum); the Czech president is widely assumed to soon cave.
One important effect of this treaty is that that Charter of Fundamental Rights of the European Union will enter into legal force - this is a different body of law that the European Court of Human Rights presides over (and whose judgments are only voluntarily adhered to), and more importantly, the CRHoEU laws will be legally enforceable across the EU. What immediately comes to mind is that the Republic of Cyprus, as a member state, will now face a review of any Cyprob settlement by the European Court of Justice if for example the human rights of refugees are not adequately respected.
Another issue is that a judgment against any party in a human rights (as opposed to a property rights case) case now must be enforced by all member states. So for example a military commander accused of war crimes against the citizens of an EU member state would not be able to travel within the EU for fear of sharing a jail cell with the likes of Roman Polanski.