SP3 is the last XP service pack, period.
Any security patches you get via Microsoft from that point on will be issued piecemeal, if at all.
I haven't run into many harware or software compatibility issues with SP3.
I've upgraded approximately 2 dozen XP SP2 machines so far, with nary a hiccup.
I'd say go for it.