The sequels trend towards fewer, longer stories with a bit more characterization as compared to Foundation, but it never really stops being a series about moments in a larger history. I’d say give either prelude to foundation or Foundation and Empire a try, but odds are if those don’t grab you, none of them will.
(importantly for those who don’t know already, the publishing dates vary widely across the series - with Foundation, Foundation and Empire, and Second Foundation released in the 50s, and the surrounding prequels and sequels arriving decades later. This can manifest as a jarring shift in writing style if you read them in chronological order instead of publishing order.)