Chesstempo's puzzles are realistic because they are from real games. I'm sure you could find a site that only has checkmate puzzles if you wanted to, and this would help you get better, though to keep getting better at chess you'll have to improve at all kinds of tactics.
In normal chess games you don't have someone to whisper in your ear, "there's a mate here" or "look for a skewer now" so that aspect is very realstic. I'm not sure what you mean by "in the realm of mate puzzles." Is there a setting on chesstempo where you're only supposed to have checkmate puzzles?
As for the board being flipped, I think perhaps you changed your settings so that White is always on the bottom.
I understand it is possible, but in the realm of mate puzzles why focus on pinning the queen instead of mating the king?
They should categorize these puzzles so we know if the intent is to mate or "play chess". I hate how chesstempo reverses the board so you have to insert the position upside down to analyze. How realistic are their puzzles?