You can be working on some pretty profoundly important projects, so yes, actually - there is plenty of room for fame in this job. No 14-year-old girl is likely to hang a poster with your face on her wall, but if what you’re looking for is recognition of your genius in a smattering of scientific journals and magazines, then your goals may be just practical enough to be realized.
Mm hm. Any time you make a breakthrough - whether it’s on the grand scale of being able to categorically prove that our entire universe exists within the skin cell of a giant, or on the slightly smaller scale of helping to design a new and improved defibrillator - you will be able to revel in the magnitude of your contribution. They may even throw you a parade. Just a small one, in the lab, but still. There might be candy.