The VG Resource

I know I can rip sprites from PC games using Ctrl Alt Print Screen, but what are the other methods?

Depends on the game. Dig around in its files and see what you see. Tools exist for ripping assets from games that use specific engines.