only "real" front rows i've ever had was for primus ar DAR, which i got through the fan club. ended up being directly in front of les. t'was a ton of fun, seeing his facial expressions up close.
i've gotten AA row seats at patriot center a few times (most recently for muse), which is front row of the sides (i.e. not floor) - excellent seats, raised off the floor.
i pulled front row orch for arcade fire, but they are all the way to the side (right against the wall). i threw them back.