Yo if you want to explore new londo with all dem ghosts. You got two ways for now. You can either buy the transistent curse from the old lady in the tunnel. It temporarily allows fighting with ghosts (5 min). Or you can get yourself cursed from these smoking frogs in the sewers
In order to save Solaire, you need to kill a specific sunlight maggot on the other side of the giant pillar door before the demon fire sage. This must be done before killing the centipede demon, as killing the centipede demon before killing the maggot will result in solaire dying. There are two ways to kill the maggot. The first is by joining the spider lady covenant and giving her 30 humanity, allowing you to open the shortcut before the fire safe and kill the maggot. The second is to get the poison mist pyromancy, going right up the the wall/door/shortcut thing, and using the mist, which will poison the maggot on the other side of the door. Then wait until the poison fully kills it, and you should be good. I know Solaire is already gone in this playthrough, but just letting you know in case you wanted to try to save him again later
Want to really feel pain. Try any Kings Field. I had platinum all soulslike from From Software since Demons Soul, and I'm playing at 1 week Kings Field 1 and I can't even finish it. That thing is crazy. Worth a try.
You can bring the fire keeper under fire link shrine back to life by using the black eye orb just before Ornstein and Smogh’s arena. You will invade the world of the person who killed her so you can take her soul back to where she was killed, restoring her.