Steam recently changed the default privacy settings for all users. This may impact tracking. Ensure your profile has the correct settings by following the guide on our forums.
I don't think any PSP games have paid DLC, but I know Wipeout Pure has downloadable track packs, and Killzone Liberation has an extra DLC chapter, both of which are free.
You can dowload then either through the game itself, or from other websites, and just drop them on the memory stick. Can't speak for other games though.