Allow me to answer not in stacks but rather in spaces (which may be appropriate if the answer is about getting intuitionintuition; e.g. for $B\mathbb{Z}/2\mathbb{Z}=\mathbb{RP}^\infty$ there is probably nothing that cannot be said without stack language). The main point I want to make is that setting up the dictionary is more subtle and doesn't work in the generality suggested by the question.
Now come the issues with the six functors: well, there is no issue for $\pi^\ast$. This exists and corresponds to restriction. However,There is an issue with $\pi_\ast$: if we look at the equivariant derived category, this is not the full derived category of $BG$ but only those with locally constant cohomology. The right adjoint functors will typically not preserve this property. This is why there is an extensive discussion on how to actually construct the functor $\pi_\ast$ in the book of [BL]. There is another issue with $\pi_\ast$: if we are only looking at the derived category of bounded complexes, then $\pi_\ast$ may not actually be defined. For example if $G$ which is not of finite cohomological dimension then the ordinary pushforward of the constant sheaf along $BG\to {\rm pt}$ will not land in the bounded derived category.
TheThere are further significant issues with the exceptional functors. First, they are not constructed in the situation for $BG\to BH$, [BL] only do this for morphisms of $G$-spaces where $G$ is fixed. ThisOne of the issues for $\pi_!$ is that the morphism $BG\to BH$ may not be related to actual problems with compactifiability ecompactifiable.g For instance, for $B\mathbb{Z}/2\mathbb{Z}\cong \mathbb{RP}^\infty$ the space is not locally compact. inSo what should $\pi_!$ for $\pi:\mathbb{RP}^\infty\to{\rm pt}$ be? We can use the definition as colimit of cohomology relative to compact subsets, in which case $BG\to {\rm pt}$$\pi_!$ will be trivial. I don't know if they existOne could use a definition via compactification but that also seems problematic for $\mathbb{RP}^\infty$. In particular, translating $\pi_!$ into group cohomology doesn't seem appropriate.
Now there is a similar issue for $\pi^!$. For $\mathbb{RP}^\infty$ we can approximate it by $\mathbb{RP}^n$. For the map $\pi_n:\mathbb{RP}^n\to{\rm pt}$ we can use Poincaré-Verdier duality to tell us that $\pi_n^\ast=\pi_n^![-2n]$. To get the result for $\mathbb{RP}^\infty$ we should take the limit which again means $\pi^!=0$.
So these are some reasons why the exceptional functors do not quite appear in this setting. What exists in any case are two induction functors (Section 3.7 of [BL]), left and right adjoint to restriction for the map $BG\to BH$ induced by a closed subgroup $G\subset H$. (This implies that the fiber of $BG\to BH$ is the homogeneous space $H/G$ and there is no infinite-dimensional contribution like the classifying space of the kernel.) [BL] denote these functors $Ind_!$ (left adjoint to Res) and $Ind_\ast$ (right adjoint to Res). In the setting of discrete groups, Section 8 of [BL] discusses the relation between the left adjoint and usual induction.
Finally, the Verdier duality holds also in equivariant derived categories. I think in the case of a Poincaré duality group (where $BG$ is actually a manifold) the dualizing sheaf should be given by the dualizing module. In general, there is no reason for a "dualizing representation" to exist, the dualizing object will just be some complex about which little can be said.