Games with a heavily dinosaur themed section:
Chrono Trigger
Secret of Evermore
Some of my favorite parts of those games are the dinosaur/prehistoric themed sections.
Games that feature lots of dinosaurs:
Jurassic Park (SNES)
Jurassic Park 2 The Chaos Continues
Jurassic Park (Genesis)
Lost World: Jurassic Park
JP for SNES, I never beat, but it's alright, and the music is great.
JP2 is a strangely cool game. It's using a little creative liberty, but it's a challenging game, and it has 2 player co-op!
JP for Genesis, is a little strange in some ways, but I enjoy it. I like how you can play as Dr. Grant or a Raptor!
LW:JP...is a little too hard for my tastes. Too linear too. You can't just play as whichever dino you want, you have to do stuff in order. And the T-Rex is weak...
I plan to have a heavy dinosaur focus in some of my RPGs, usually with playable dinosaurs!