>>23020362X on the Xbox is the best version (it has a shitload of levels, including all of the original THPS), but you said consoles, as in plural, which is wrong because you are retarded.
The only other consoles that THPS2 was released on were the PS1 and the N64. The PS1 version is solid,but the N64 version is blurry ass with a butchered soundtrack and is nigh unplayable with the godawful N64 controller (pic is from THPS3, but you get the idea).
On a side note, the GBA THPS games were pretty awesome. They ditched 3D for an isometric view that surprisingly worked out really well. Only downside was that the control scheme suffered a little due to the GBA only having two buttons for some stupid reason.
DC version is nice because it's super easy to replace the .adx files on burned copies so you can replace the soundtrack with converted .mp3s if you want. The Xbox version still triumphs on account of the custom soundtrack feature though.