Everyone in here needs to
1. Get a flash drive (thumb drive, whatever you prefer to call it) of darn near any size. (the mods that are even usable on the PS3 aren't going to be that big... And there are no COMPLETED total conversions on the PS3 yet, as the people who make those don't give much love to the console)
2. Get Unreal Tournament 3. If the gore bothers you, you can turn it off.
3. Visit this site:
http://www.ut3mod.com It's really outdated, but the old mods are still good, and EVERYTHING on the site is made for PS3, so it's easier than trying to sort through the forums that feature both PS3 and PC. You can download the mods directly on the PS3, but word of warning: It's a slow process, and you can only load one mod per device. If you have 4 flash drives (and 4 USB slots on your PS3 or a hub) you can do it a bit faster and do 4 per UT3 session. When you save, make sure the icon is on your flash drive, and press start, not X. It has to save to the root.
4. Register at
http://forums.beyondunreal.com for NEW mods. They're under content releases. You can limit views to UT3 releases only, and sort by thread post, so you see the most recent maps first.
I play UT3 with friends every Saturday (my time... Friday night California time) We always look for new mods to play.