Meh, Ogden is fine...it is just a mountain town. Territorial people....I just didn't get a friendly vibe like some other towns I've passed-through. There are definitely a couple of bars that'll keep you entertained. I'm sure your main focus is riding, so I wouldn't let SLC weigh too heavily in your considerations for a place to go. Crash and drink in Ogden, Ride Pow Mow and Basin. Have fun and post photos!
To me Ogden is more like a sprawled out blue collar kind of industrial/mining town , old school mountain town maybe. Historic Main Street has some neat places to stop in and see eat/drink/party but nothing life changing also most of the usual chain places....finding a sports bar won't be an issue. nothing to see at those two resorts once the lifts stop spinning it's only a 30-40 minute drive to Ogden for cheap beds and food.
Crazy awesome terrain at PowMow, careful if you decide to drive all the way to the top, powder country is epic one of my favorite inbounds places to ride anywhere(ride the free bus back to the top bring a PBRTB for the wait) andSnowbasin, 3-4 comfy super high speed gondolas cover almost the entire mtn, The best views and longest runs in all of Utah. ......you won't find two resorts more different than each other yet equally cool. Best public bathrooms of any resort/hotels anywhere they won some kind of award last year something.