I think downtown Mpls is absolutely vibrant. There are a ton of eating choices, both upscale and not, which means that the restaurant rebirth you started to witness was successful. They’ve added a new “entertainment block,” called Block E, right across from the Target Center where there’s lots to do - there’s movies, an arcade, a coupla bars, an ice cream joing, and various eating establishments. I believe one of the bars there does “Dueling Pianos,” which SpouseO saw in Rochester, MN and really liked. If that’s your thing, there you are. It’s also near the new Hard Rock that opened recently.
There’s a ton of theaters in the area - whether they’re playing anything, however, is anyone’s guess. There’s the State, the Orpheum, and the Pantages. I believe they’re all run by the same company, so if you search for the Orpheum, you might get listings for what’s playing for all three. Not sure on this, tho’. They’re all close together on the same block (not far from the aforementioned Block E). In addition, there’s another theater in that block that was routinely playing audience participation things like Tony and Tina’s wedding - not sure what they’ve got going now, but it’s a possibility. I can’t remember its name, however.
As for eats, if you like tapas (Spanish for “little plates”), there’s a really good tapas place called Solera in the theater block. They’ve got a ton of choices, so if you’re feeling adventurous, you can’t go wrong here. Good stuff. If you head further west towards the warehouse district, there’s a latin-inspired place called Babalu (kinda spendy, tho’) that’s good and has live music on the weekends, and also Sapor good bistro with excellent food (again, spendy). Down that way there’s also a really nice wine bar with a limited appetizer menu, but I forget its name. Closer to downtown, you also have your TGI Friday’s, Applebees, and Olive Garden for less expensive eats. I don’t know about mexican - there is a Tex-Mex place, but it’s just okay (IMO).
On the way back to downtown, you could stop by the three level Sex World for a laugh - you can’t miss its neon.
Nicollet mall is a good place for shopping - there’s some boutiques, a really nice art gallery, and your Barnes and Noble that’s always a guaranteed time sink.
There’s also a lot of areas downtown Mpls that you can get live music - the Fine Line and 1st Avenue spring immediately to mind, but there’s a bunch more. 1st Ave is more of the small venue concert type place, while the Fine Line is more of a bar that has bands. There’s also a couple of jazz clubs towards downtown’s southern end, and you can get Salsa on Saturday if you head to the Minnepolis Cafe in that area. There’s also a Buca di Peppo (family-style Italian restaurant in the sicilian mode - mostly tomato/meat, not a lot of cream-style dishes) down there that’s excellent and Tiburon, a seafood place (spendy) that I’ve enjoyed.
The Grand Avenue area in St. Paul is a really nice and easy place to spend some time wandering and shopping. I haven’t been (I’ve only driven through), but I’m certain you could find something there that interests you.
If you like blues, I definitely recommend the Famous Dave’s in Uptown - it’s a huge establishment with live music every weekend. It’s a fun night. I haven’t explored it much, but the rest of Uptown seems like fun too.
If you’re inclined, I’d take a walk around St. Paul to see as many of the Peanuts statues as possible - while most have moved to other homes, there’s still a bunch around, especially in Rice Park across from the Ordway Theater, which might be playing something nice. While you’re in St. Paul, check out the Science Museum if you’re so inclined - its IMAX is playing something about Mt. Kilomanjaro, which my Mom-in-law pretty rabidly wants to see. Keep in mind, however, that while St. Paul is really nice, it’s generally pretty dead on weekends.
As for hotels, there’s a Radisson, a Hyatt, and a Mariott right there in the downtown area (the Hyatt is south), and there’s a Holiday Inn I believe that’s closer to the U/Metrodome area (while you’re there, you could eat at Grandma’s, if you were so inclined). I know there’s a bunch more, but I can’t think of them.
Whew! So, maybe I’ll give someone else a chance, hey?