tl;dr? Skip to the photoacoustic stuff at the end, which is amazing.
I feel like I didn't do MRI justice there, as it's really a family of techniques. You can tune the pulse sequences to image a lot of different things: a T1 scan of the brain, for example, emphasizes white vs. grey matter; T2* highlights fluids. fMRI uses slight changes in the properties of oxygenated vs. deoxygenated blood to infer brain activity, rather that structure. You can even find the distribution of other chemicals via Magnetic Resonance Spectroscopy. People use this to see if levels of neurotransmitters vary in the brain. However, you need some water/protons to image, which is why this works poorly for bone.
PET uses radioactive tracers that either bind to or replace other substances in the body. For example, in a cancer studies you're given a sugar analog called Fludeoxyglucose, or FDG. Different tissues take up glucose at different rates, and metastatic tumors are particularly hungry for it, so a lot of FDG ends up near the tumor. As it decays into oxygen and sugar, it emits positrons, the antiparticle of electrons. When the positron interacts with an electron in body's own matter, it gives off two photons that fly in opposite directions. By measuring coincidences across a set of detectors, you can figure out where the positron came from and the tracer and the tumor must be near by. FDG is the most common, but you can radiolabel lots of other things too, including drugs.
SPECT is similar, in that it uses a radioactive tracer. The SPECT tracers usually emit gamma radiation directly though, and the detector is a bit different--it doesn't rely on coincidences, which makes it cheaper but a bit lower resolution. An even simpler option is a gamma camera, where you get a single 2D image (like an X-ray vs a CT scan); not sure if this is still used much.
Ultrasound you undoubtedly know from people having babies. It gets used to look at other soft tissue too, especially knees. Ultrasound of the heart are often called echocardiograms.
Photoacoustic techniques are absolutely wild. You shine a light (usually a laser) into the subject. The wavelength of this light is carefully chosen so that it a) passes through stuff that's in the way and b) is absorbed by whatever you want to image. When a substance absorbs light, it heats up and when things heats up, they expand. Rapidly expanding things make pressure waves (i.e., sounds). By detecting those sounds from multiple locations, you can figure out where things of that color are. The color of blood varies slightly depending on how oxygenated it is, so you could potentially use this to figure out what parts of the brain are using more oxygen--and thus more active, just like fMRI. (This sounds terrifying, but the temperature changes are minuscule).