Paramount's Great America is your standard roller coaster theme park, not unlike any "Six Flags" roller coaster them park you would find anywhere else in the states.
That said, the park does have lots of different coasters, including Top Gun, where your legs dangle off the coaster, Grizzly, a wooden, rickety roller coaster, and Invertigo, where the coaster shoots you forwards and backwards for a really wacko ride.
Food at the park, not surprisingly, is not cheap and rather expensive. A burger can cost you upwards of $9 for crappy theme-park food; a Coke runs you $3.
That said, if you've got thrill-seeking little kids, then Great America is a great place to take them as there isn't many other options in Silicon Valley.