The PS3 never hosted a true "WoW-killer" MMORPG. Hardware limits (256MB XDR + 256MB GDDR3 RAM, split pool) and Sony's certification process made massive persistent worlds impractical. However, three titles scratch the itch:
Play FFXIV or ESO on PS4/PS5/PC. They are the modern giants. PS3 is a dead end for MMORPGs. If you must use PS3: DCUO is the only living one, but it's a shadow of its PC/PS4 version.