Basically speaking, the theory of asymptotics using the framework of decision theory is much tougher than most mathematicians think nowadays if they ever read into [Le Cam]'s exposition. This kind of difficulty mostly arise from two sources, from my perspective. The first one is the typical difficulty in determination of loss function, convexity is convenient yet concavity is a more faithful description of boundary behavior (when sequence of rules tends to $\infty$, in most cases we consider the rules indexed by sample sizes $n$.), this flaws are very carefully(probably over-carefully discussed in pp.16-23 of [Le Cam]). The second one is closer to what you think in OP, that is the inconsistency between local and global asymptotic behaviors, which is also discussed in Chap.10-11 of [Le Cam]. This problem is becoming more and more central concern in recent research, you may also want to read my post Is there a result that provides the bootstrap is valid if and only if the statistic is smooth?Is there a result that provides the bootstrap is valid if and only if the statistic is smooth?, which explained why sometimes seemingly unnecessary "linearity conditions" will be imposed on some asymptotic results.
There are quite a few examples that concentration bound disagrees with asymptotic bound as I mentioned above shown in [Talagrand] and [Le Cam]Chap 10-11. But the most famous example that fits your description should be the order statistics from extreme value theory, its asymptotic distribution is exponential (Limiting distribution of the first order statistic of a general distributionLimiting distribution of the first order statistic of a general distribution) while the distribution of finite sample order statistics $(X_{(1)},\cdots,X_{(n)})$ always depends on the underlying distribution itself. Not surprisingly the Efron-Stein concentration bound is much looser in this case. So what I said is that such disagreement between concentration bound and asymptotic bound is rather common.